Postgres Pro
Downloads
Home   >   mailing lists

Re: [INSERT]Return a value - Mailing list pgsql-novice

From Leví Teodoro da Silva
Subject Re: [INSERT]Return a value
Date
Msg-id 4a74ba520811070604g7e630e96h7159f435db37c40e@mail.gmail.com
Whole thread Raw
In response to Re: [INSERT]Return a value  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [INSERT]Return a value
List pgsql-novice
Tree view
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@sss.pgh.pa.us>
"Leví Teodoro da Silva" <tlevisilva@gmail.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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: [INSERT]Return a value
Next
From: Tom Lane
Date:
Subject: Re: [INSERT]Return a value