Received: from bjke.com (firewall-user@ganymede.bjke.com [144.210.8.38]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA08770 for ; Mon, 17 May 1999 14:04:32 -0400 (EDT) (envelope-from djackson@cpsgroup.com) Received: by bjke.com; id NAA19229; Mon, 17 May 1999 13:04:16 -0500 (CDT) Received: from unknown(144.210.12.10) by gauntlet.bjke.com via smap (4.1) id xma018569; Mon, 17 May 99 13:03:15 -0500 Received: by cpsmail with Internet Mail Service (5.5.2448.0) id ; Mon, 17 May 1999 13:03:35 -0500 Message-ID: From: "Jackson, DeJuan" To: Mario Olimpio de Menezes , pgsql-sql@postgreSQL.org Subject: RE: [SQL] Delete with AND Date: Mon, 17 May 1999 13:03:34 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: text/plain That statement should work just fine (assuming $CartCookie and $ItemID are perl variable to be expanded before sent to the DB or that the strings actually contain those values). You may be having trouble with the uppercase column and table names if the tables in the database are actually that case then you'll need to double-quote the table and column names. -DEJ > 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 purpose that prevails" > http://curiango.ipen.br/~mario Prov. 19.21 >