Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 6F56D9FA22C for ; Wed, 22 Nov 2006 13:27:08 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 29156-03 for ; Wed, 22 Nov 2006 17:26:59 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web31813.mail.mud.yahoo.com (web31813.mail.mud.yahoo.com [68.142.207.76]) by postgresql.org (Postfix) with SMTP id 0C0E49F9F27 for ; Wed, 22 Nov 2006 13:26:58 -0400 (AST) Received: (qmail 28012 invoked by uid 60001); 22 Nov 2006 17:26:57 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=0JDvRwlFb5Qd/8+5h5OJF7+awpYF6fiNWneSJtNGhBL/YA+0BzFIoJBmld9E6KAVM8+R7LyOSbMsEOJ9zoMauZzlh6iG0ekxirN/t56PmD0FeASZBI0i79/kjM2U2KsAirMhXRC4k3a5t+GjCs7YECVr/Wd6N9MtdUep1bXEnKQ= ; X-YMail-OSG: 8jxbVAIVM1mJPaBTEi0o6QyjoRpM5r2LpV_Iy5oSPI3KTP4AtyhfC_e9OL448EwWPQ-- Received: from [65.211.203.79] by web31813.mail.mud.yahoo.com via HTTP; Wed, 22 Nov 2006 09:26:57 PST Date: Wed, 22 Nov 2006 09:26:57 -0800 (PST) From: Richard Broersma Jr Subject: Re: select into To: Andreas Kretschmer Cc: SQL Postgresql List In-Reply-To: <20061122160733.GA29180@KanotixBox> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <746415.27992.qm@web31813.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.756 tagged_above=0 required=5 tests=BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: X-Archive-Number: 200611/232 X-Sequence-Number: 26884 --- Andreas Kretschmer wrote: > Richard, the plain SQL "INSERT INTO " is an other thing as the > original problem... > > He is in a PL/pgsql - function and he should rewrite this to use EXECUTE > ... INTO > I see, I am not even a novice yet when it comes PL/pgsql. Thanks for the clarification. Regards, Regards, Richard Broersma Jr.