Skip site navigation (1) Skip section navigation (2)

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

From: tushar <tushar(dot)ahuja(at)enterprisedb(dot)com>
To: Brad Constantinescu <brad(dot)constantinescu(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4704: syntax error at or near "RETURNING"
Date: 2009-03-14 13:45:20
Message-ID: 49BBB4F0.4030908@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-bugs
-----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-----

In response to

pgsql-bugs by date

Next:From: Pavel StehuleDate: 2009-03-14 15:47:04
Subject: Re: BUG #4704: syntax error at or near "RETURNING"
Previous:From: Tomasz OlszakDate: 2009-03-14 13:13:05
Subject: Bug? Problem with accesing Oracle from plperlu function?==?UTF-8?Q? when using remote pg client.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group