As others have pointed out '||' is concatenation, you are looking for
'OR'.
But possibly a nicer way is '... WHERE column IN (value1, value2,
value4, value5);'
Dmitri
-----Original Message-----
From: Dennis Gearon [mailto:gearond@cvc.net]
Sent: Thursday, May 01, 2003 2:03 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] deleting multiple rows
A very simple SQL question, LOL.
If I want to delete multiple rows, I can use '||' to do it like this,
right?
DELETE FROM TableName
WHERE
column = value1 ||
column = value2 ||
column = value4 ||
column = value5
;
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org