Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id D9D099F9A5F for ; Tue, 14 Aug 2007 03:17:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 54763-06 for ; Tue, 14 Aug 2007 03:17:18 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 0F3E69F9ABA for ; Tue, 14 Aug 2007 03:17:18 -0300 (ADT) Received: (qmail 28949 invoked by uid 0); 14 Aug 2007 06:17:17 -0000 Received: from 84.75.95.14 by www160.gmx.net with HTTP; Tue, 14 Aug 2007 08:17:17 +0200 (CEST) Cc: pgsql-sql@postgresql.org Content-Type: text/plain; charset="us-ascii" Date: Tue, 14 Aug 2007 08:17:17 +0200 From: "Christian Kindler" In-Reply-To: <20582.1187034940@sss.pgh.pa.us> Message-ID: <20070814061717.201170@gmx.net> MIME-Version: 1.0 References: <20070813192952.76820@gmx.net> <20582.1187034940@sss.pgh.pa.us> Subject: Re: how to move back in refcursor To: Tom Lane X-Authenticated: #27759442 X-Flags: 0001 X-Mailer: WWW-Mail 6100 (Global Message Exchange) X-Priority: 3 X-Provags-ID: V01U2FsdGVkX1/z7isNcMPzuhMKp6kDF3gGyIpBCzX5hk0EDeP8fu jkoKREAkNL7l+InFekPbtUpwKEMf32PoDP9g== Content-Transfer-Encoding: 7bit X-GMX-UID: iDmoKed2MydhZwXGzWtlqXpjaGRhZhpX X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.109 tagged_above=0 required=5 tests=AWL=0.294, BAYES_40=-0.185 X-Spam-Level: X-Archive-Number: 200708/120 X-Sequence-Number: 29058 Oh I see .... But damn I need it in plpgsql because all my Application logic is delevoped in the backend. Ok maybe I can work around this. Thank you very much! Chris -------- Original-Nachricht -------- Datum: Mon, 13 Aug 2007 15:55:40 -0400 Von: Tom Lane An: "Christian Kindler" CC: pgsql-sql@postgresql.org Betreff: Re: [SQL] how to moce back in refcursor > "Christian Kindler" writes: > > -- move -1 in cur1; > > plpgsql supports that in CVS HEAD (8.3-to-be) but not in any existing > release. You'll need to rethink your logic or do this from your > application rather than within plpgsql. > > regards, tom lane -- cu Chris Ist Ihr Browser Vista-kompatibel? Jetzt die neuesten Browser-Versionen downloaden: http://www.gmx.net/de/go/browser