Re: Using RETURNING with INTO inside pgsql

I have to agree with both of you...
But unfortunately there are still some loose ends... See bug 3596...

http://archives.postgresql.org/pgsql-bugs/2007-09/msg00009.php

But leaving bugs aside, I will have to say "Bravo!" to the development team!

Ciprian Craciun.

P.S.: I forgot to press reppy all...

On 9/21/07, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> On 9/21/07, D. Dante Lorenso <dante(at)lorenso(dot)com> wrote:
> > Not really a question here, I just wanted to share my joy with the
> > group. I'm loving the new RETURNING clause in PostgreSQL. This is
> > really cool stuff ...
>
> I love it too! I have an update for out monitoring software that does
> something like:
>
> insert into monitoring table (a,b,c,thredhols) select distinct a,b,c,
> 50 from bigtable where date > now() - interval '24 hours' returning
> a,b,c
>
> and it is so much simpler than how I had to do it before, mostly in app code.
>
> Every time I turn around there's something new in postgresql that
> makes me love it that much more.
>
> I owe somebody a whole bunch of pizza...
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>