Postgres Pro
Downloads
Home   >   mailing lists

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

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