Re: INSERT WHERE NOT EXISTS

From: Jonathan Bartlett <johnnyb(at)eskimo(dot)com>
To: "Reuben D(dot) Budiardja" <techlist(at)voyager(dot)phys(dot)utk(dot)edu>
Cc: Ian Barwick <barwick(at)gmx(dot)net>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: INSERT WHERE NOT EXISTS
Date: 2003-06-25 20:21:43
Message-ID: Pine.GSU.4.44.0306251321010.9057-100000@eskimo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> > This kind of query should work; just leave out the "FROM dummy_table" bit.
> > (in Oracle it would be "FROM dual").

What's really fun is to insert extra records into "dual" on Oracle systems
and watch all the applications crash :)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mike Mascari 2003-06-25 20:23:41 Re: INSERT WHERE NOT EXISTS
Previous Message Tom Lane 2003-06-25 20:11:30 Re: Many Pl/PgSQL parameters -> AllocSetAlloc(128)?