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.marlowe@xxxxxxxxx> wrote: > On 9/21/07, D. Dante Lorenso <dante@xxxxxxxxxxx> 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 > ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
