Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id C4DE89FA0FB for ; Mon, 4 Dec 2006 08:13:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 68077-07 for ; Mon, 4 Dec 2006 08:13:36 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by postgresql.org (Postfix) with ESMTP id 3336A9FA0EE for ; Mon, 4 Dec 2006 08:13:36 -0400 (AST) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1GrChJ-0007t8-MK for pgsql-admin@postgresql.org; Mon, 04 Dec 2006 13:13:25 +0100 Received: from pirus.securax.be ([213.16.46.130]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 04 Dec 2006 13:13:25 +0100 Received: from milen by pirus.securax.be with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 04 Dec 2006 13:13:25 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: "Milen A. Radev" Subject: Re: insert and returning Date: Mon, 04 Dec 2006 14:12:58 +0200 Lines: 16 Message-ID: <457410CA.7020001@radev.net> References: <0BA77301DFF4B24C9C5DAA74138BF95003C7AE@exchange-1.dbnet.co.il> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: pirus.securax.be User-Agent: Mozilla Thunderbird 1.5.0.8 (Windows/20061025) In-Reply-To: <0BA77301DFF4B24C9C5DAA74138BF95003C7AE@exchange-1.dbnet.co.il> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/24 X-Sequence-Number: 23816 Doron Baranes написа: > Hi, > > can someone help me with an example of how to use the returning clause of an insert > to return a column value from the row inserted? > Look at the bottom of this page - http://developer.postgresql.org/pgdocs/postgres/sql-insert.html OTOH this functionality is available only in v8.2 (as you could guess from the URL), but that version should be released tomorrow. -- Milen A. Radev