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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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