Re: BUG #4704: syntax error at or near "RETURNING"

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Brad Constantinescu wrote:

>
> This is my code:
> INSERT INTO orase (id, nume, judet_id, nr_sectoare)
> VALUES (DEFAULT,'Medias', 34, 0)
> RETURNING id;
>
if you see the help , there is no term Returning in PG 8.1,see below

postgres=# \h insert
Command: INSERT
Description: create new rows in a table
Syntax:
INSERT INTO table [ ( column [, ...] ) ]
{ DEFAULT VALUES | VALUES ( { expression | DEFAULT } [, ...] ) | query }

postgres=# select version();
version
- -----------------------------------------------------------------------------------------------------
PostgreSQL 8.1.15 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20071124 (Red Hat 4.1.2-42)
(1 row)

postgres=#

--
regards,tushar
http://webeatoracle.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQFJu7TvfQNodY2PIRoRApquAJ0UefzDYcpAhZ3wGrzEGn8VdIcplwCfTAFG
OfuWnNy4Sl0l2eux5WumZFQ=
=aBh8
-----END PGP SIGNATURE-----