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

Re: [INSERT]Return a value

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Leví Teodoro da Silva <tlevisilva(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [INSERT]Return a value
Date: 2008-11-07 14:07:26
Message-ID: 29353.1226066846@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
"=?ISO-8859-1?Q?Lev=ED_Teodoro_da_Silva?=" <tlevisilva(at)gmail(dot)com> writes:
> When  try to execute it on pgadmin :
> BEGIN;
> INSERT INTO "Login"(
>             "CPF", "password", status, "idSeller")
>     VALUES ('1', '1', 'ok', '1') RETURNING "CPF";
> COMMIT;

> I got the follow :
> *Query result with 1 rows discarded*

Is that a current version of pgAdmin?  If so, you need to complain to
the pgAdmin folks.  If it's not current, it might not know about
RETURNING.

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Andreas KretschmerDate: 2008-11-07 14:47:09
Subject: Re: [INSERT]Return a value
Previous:From: Leví Teodoro da SilvaDate: 2008-11-07 14:04:13
Subject: Re: [INSERT]Return a value

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