Postgres Pro
Downloads
Home   >   mailing lists

Re: INSERT WHERE NOT EXISTS - Mailing list pgsql-general

From Jonathan Bartlett
Subject Re: INSERT WHERE NOT EXISTS
Date
Msg-id Pine.GSU.4.44.0306251321010.9057-100000@eskimo.com
Whole thread Raw
In response to Re: INSERT WHERE NOT EXISTS  ("Reuben D. Budiardja" <techlist@voyager.phys.utk.edu>)
List pgsql-general
Tree view 
> > 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 :)

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: INSERT WHERE NOT EXISTS
Next
From: Mike Mascari
Date:
Subject: Re: INSERT WHERE NOT EXISTS