Delete with AND - Mailing list pgsql-sql

From Mario Olimpio de Menezes
Subject Delete with AND
Date
Msg-id Pine.LNX.3.96.990517120826.139D-100000@curiango.ipen.br
Whole thread Raw
List pgsql-sql
Hi,
       I'm trying to port some perl scripts that used MySql to Postgres
and I'm having problems with a delete statement.       With MySql, the script has a line like this:
DELETE FROM CartItems WHERE UserID='$CartCookie' AND ItemID='$ItemID'       How can I use such delete statement in
Postgres?      Is there another way to do this?       Please, help and if possible cc to my e-mail as I'm not currently

subscribed to this list.       Thanks,

[]s,
Mario O.de Menezes            "Many are the plans in a man's heart, but   IPEN-CNEN/SP                 is the Lord's
purposethat prevails"
 
http://curiango.ipen.br/~mario                 Prov. 19.21



pgsql-sql by date:

Previous
From: Mario Olimpio de Menezes
Date:
Subject: delete with and
Next
From: José Soares
Date:
Subject: Re: [SQL] Oddities with NULL and GROUP BY