Re: deleting multiple rows

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