Re: deleting multiple rows - Mailing list pgsql-general

On Thu, 1 May 2003, Dennis Gearon wrote:

> A very simple SQL question, LOL.
>
> If I want to delete multiple rows, I can use '||' to do it like this, right?

|| is generally concatenate.  You'll want to use OR.

> DELETE FROM TableName
> WHERE
>     column = value1 ||
>     column = value2 ||
>     column = value4 ||
>     column = value5
> ;