Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id CC55763243E for ; Fri, 20 Aug 2010 06:27:30 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 21866-07 for ; Fri, 20 Aug 2010 09:27:22 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mailout-de.gmx.net [213.165.64.22]) by mail.postgresql.org (Postfix) with SMTP id 2E211632377 for ; Fri, 20 Aug 2010 06:27:22 -0300 (ADT) Received: (qmail 28884 invoked by uid 0); 20 Aug 2010 09:27:21 -0000 Received: from 192.124.237.7 by www138.gmx.net with HTTP; Fri, 20 Aug 2010 11:27:18 +0200 (CEST) Content-Type: text/plain; charset="utf-8" Date: Fri, 20 Aug 2010 11:27:18 +0200 From: Jan-Peter.Seifert@gmx.de In-Reply-To: <20100820084433.243470@gmx.net> Message-ID: <20100820092718.243470@gmx.net> MIME-Version: 1.0 References: <20100820084433.243470@gmx.net> Subject: Re: query fine in psql/pgAdmin III but error message when within plpgsql function To: "Jan-Peter Seifert" , pgsql-admin@postgresql.org X-Authenticated: #955937 X-Flags: 0001 X-Mailer: WWW-Mail 6100 (Global Message Exchange) X-Priority: 3 X-Provags-ID: V01U2FsdGVkX19LP5IuTXVLC3pU6uQVk0ajsEYp/s0bUw0/HUo7Cf 6WEZW1oq/nxPOVUBm3F5z/BeRn6dIpsHWlBw== Content-Transfer-Encoding: 8bit X-GMX-UID: GCcMGFx/bXB+XETkPDQ28hciLyUmZQh5 X-FuHaFi: 0.70999999999999996 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-10 required=5 tests=BAYES_50=0.8, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201008/138 X-Sequence-Number: 35387 Ouch. My mistake. :( The copy had of course duplicate data sets, because I trapped errors during its creation and because of the missing 'WHERE 1=0'. Sorry, Peter -- GMX DSL SOMMER-SPECIAL: Surf & Phone Flat 16.000 für nur 19,99 ¿/mtl.!* http://portal.gmx.net/de/go/dsl