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

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 (view raw or flat)
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

pgsql-novice by date

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

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