On 9/21/07, D. Dante Lorenso <dante@lorenso.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...