deleting multiple rows

From: Dennis Gearon <gearond(at)cvc(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: deleting multiple rows
Date: 2003-05-01 18:03:25
Message-ID: 3EB1616D.1030200@cvc.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
;

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2003-05-01 18:20:05 Re: deleting multiple rows
Previous Message Michael Meskes 2003-05-01 17:27:32 binaries for RH advanced server