Re: [INSERT]Return a value

From: Leví Teodoro da Silva <tlevisilva(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: [INSERT]Return a value
Date: 2008-11-07 13:49:45
Message-ID: 4a74ba520811070549k4c10f272ye5660a8e23e6e7aa@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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 possible !?

Thanks,
Leví

2008/11/7 A. Kretschmer <andreas(dot)kretschmer(at)schollglas(dot)com>

> 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
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2008-11-07 13:50:56 Re: [INSERT]Return a value
Previous Message A. Kretschmer 2008-11-07 13:34:38 Re: [INSERT]Return a value