pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jackson, DeJuan <djackson@cpsgroup.com>
To: Mario Olimpio de Menezes <mario@curiango.ipen.br>
To: pgsql-sql@postgreSQL.org
Subject: RE: [SQL] Delete with AND
Date: Mon, 17 May 1999 13:03:34 -0500
Message-ID: <D05EF808F2DFD211AE4A00105AA1B5D216F018@cpsmail> (raw)

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
> 



view thread (3+ messages)

Message-ID: <D05EF808F2DFD211AE4A00105AA1B5D216F018@cpsmail>
Permalink:  ../D05EF808F2DFD211AE4A00105AA1B5D216F018@cpsmail/
Also on:    postgresql.org/message-id/D05EF808F2DFD211AE4A00105AA1B5D216F018@cpsmail

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: djackson@cpsgroup.com, mario@curiango.ipen.br
  Subject: Re: [SQL] Delete with AND
  In-Reply-To: <D05EF808F2DFD211AE4A00105AA1B5D216F018@cpsmail>
  References: <D05EF808F2DFD211AE4A00105AA1B5D216F018@cpsmail>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox