| From: | Ian Barwick <barwick(at)gmx(dot)net> |
|---|---|
| To: | Mike Mascari <mascarm(at)mascari(dot)com> |
| Cc: | techlist(at)voyager(dot)phys(dot)utk(dot)edu, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: INSERT WHERE NOT EXISTS |
| Date: | 2003-06-25 19:53:16 |
| Message-ID: | 200306252153.16806.barwick@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wednesday 25 June 2003 21:37, Mike Mascari wrote:
> Ian Barwick wrote:
> > On Wednesday 25 June 2003 20:06, Reuben D. Budiardja wrote:
(...)
> > This kind of query should work; just leave out the "FROM dummy_table"
> > bit. (in Oracle it would be "FROM dual").
>
> I proposed that same solution 3 years ago. Tom shoots it down:
>
> http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=3A4D611
>6.1A613402%40mascari.com&rnum=1&prev=/groups%3Fq%3DMike%2BMascari%2BINSERT%2
>BNOT%2BEXISTS%26ie%3DUTF-8%26oe%3DUTF-8%26hl%3Den
>
> Reuben must be prepared for unique key violation, I'm afraid. And,
> despite the optimism in the link, we still don't have savepoints. :-(
aha, useful to know. Thanks.
Ian Barwick
barwick(at)gmx(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | johnnnnnn | 2003-06-25 19:56:24 | Re: [GENERAL] Physical Database Configuration |
| Previous Message | Reuben D. Budiardja | 2003-06-25 19:53:01 | Re: INSERT WHERE NOT EXISTS |