Re: [INSERT]Return a value

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*

Query returned successfully with no result in 0 ms.

But i dont want discard the result =/

Thanks,
Leví

2008/11/7 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>

> "=?ISO-8859-1?Q?Lev=ED_Teodoro_da_Silva?=" <tlevisilva(at)gmail(dot)com> writes:
> > INSERT INTO "Login"(
> > "CPF", "password", status, "idSeller")
> > VALUES ('108', '12345', 'ok', '2555') RETURNING "CPF" INTO STRICT
> teste;
>
> It looks like you are trying to do this at the SQL level, in which case
> you should leave off the INTO bit.
>
> regards, tom lane
>