Delete with AND

Поиск
Список
Период
Сортировка
От Mario Olimpio de Menezes
Тема Delete with AND
Дата
Msg-id Pine.LNX.3.96.990517120826.139D-100000@curiango.ipen.br
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Mario Olimpio de Menezes
Дата:
Сообщение: delete with and
Следующее
От: José Soares
Дата:
Сообщение: Re: [SQL] Oddities with NULL and GROUP BY