Re: deleting multiple rows

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Dennis Gearon <gearond(at)cvc(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: deleting multiple rows
Date: 2003-05-01 18:20:05
Message-ID: 20030501111715.B29450-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
> ;

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2003-05-01 18:20:49 Re: deleting multiple rows
Previous Message Dennis Gearon 2003-05-01 18:03:25 deleting multiple rows