Re: [INSERT]Return a value

Re: [INSERT]Return a value

am  Fri, dem 07.11.2008, um 11:21:05 -0200 mailte Leví Teodoro da Silva folgendes:
> Hi guys,
> 
> I was looking for something like the follow but i dont get ...
> 
> I want to do two inserts. In my first insert i want that the query returns a
> result for me and in the second, i want that the postgres just insert the
> values in my table.

IIRC, you can't use the RETURNING value for a neu INSERT, it is a TODO
for the next release.


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

Re: [INSERT]Return a value

Leví Teodoro da Silva  schrieb:

> Andreas,
> 
> I dont want to insert the values that the first insert returned in the second
> insert, i just want to receive the return value from the first query and after
> i want to execute a different query not related with the first. Is it not

Sorry, i misunderstood the question.


Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

Re: [INSERT]Return a value

"=?ISO-8859-1?Q?Lev=ED_Teodoro_da_Silva?="  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

Re: [INSERT]Return a value

"=?ISO-8859-1?Q?Lev=ED_Teodoro_da_Silva?="  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

[INSERT]Return a value

Re: [INSERT]Return a value

Re: [INSERT]Return a value