On Mon, Jul 08, 2002 at 03:18:33 +0200, Joachim Trinkwitz <[EMAIL PROTECTED]> wrote: > Hi, > > I want to insert a row only under condition that there isn't already > another row with similar values -- something like a INSERT INTO > ... WHERE NOT EXISTS (SELECT ...)?
You can do something like the following: insert into tab (col1, col2, col3) select 'val1', 'val2', 'val3' where not exists (select * from tab where col1 = 'val1' and col2 = 'val2' and col3 = 'val3'); ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
