| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "D(dot) Dante Lorenso" <dante(at)lorenso(dot)com> |
| Cc: | Postgres-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Using RETURNING with INTO inside pgsql |
| Date: | 2007-09-21 05:23:59 |
| Message-ID: | dcc563d10709202223p42db6518q6078533aa87abc4d@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amrita Prasad | 2007-09-21 05:38:21 | How to display geometry data using java and PostGIS |
| Previous Message | D. Dante Lorenso | 2007-09-21 05:12:22 | Using RETURNING with INTO inside pgsql |