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-----