Postgres Pro
Downloads
Home   >   mailing lists

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

From Leví Teodoro da Silva
Subject Re: [INSERT]Return a value
Date
Msg-id 4a74ba520811070549k4c10f272ye5660a8e23e6e7aa@mail.gmail.com
Whole thread Raw
In response to Re: [INSERT]Return a value  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Responses Re: [INSERT]Return a value
List pgsql-novice
Tree view
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.kretschmer@schollglas.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

pgsql-novice by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: [INSERT]Return a value
Next
From: Tom Lane
Date:
Subject: Re: [INSERT]Return a value