Re: [INSERT]Return a value
| От | Leví Teodoro da Silva |
|---|---|
| Тема | Re: [INSERT]Return a value |
| Дата | |
| Msg-id | 4a74ba520811070604g7e630e96h7159f435db37c40e@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [INSERT]Return a value (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: [INSERT]Return a value
|
| Список | pgsql-novice |
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í
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:It looks like you are trying to do this at the SQL level, in which case
> INSERT INTO "Login"(
> "CPF", "password", status, "idSeller")
> VALUES ('108', '12345', 'ok', '2555') RETURNING "CPF" INTO STRICT teste;
you should leave off the INTO bit.
regards, tom lane
В списке pgsql-novice по дате отправления: