Skip site navigation (1) Skip section navigation (2)

Re: [INSERT]Return a value

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Leví Teodoro da Silva <tlevisilva(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [INSERT]Return a value
Date: 2008-11-07 13:50:56
Message-ID: 29005.1226065856@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
"=?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

In response to

Responses

pgsql-novice by date

Next:From: Leví Teodoro da SilvaDate: 2008-11-07 14:04:13
Subject: Re: [INSERT]Return a value
Previous:From: Leví Teodoro da SilvaDate: 2008-11-07 13:49:45
Subject: Re: [INSERT]Return a value

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group