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(at)cvc(dot)net]
Sent: Thursday, May 01, 2003 2:03 PM
To: pgsql-general(at)postgresql(dot)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