executing delete in a case statement?

Поиск
Список
Период
Сортировка
От Jean-Christian Imbeault
Тема executing delete in a case statement?
Дата
Msg-id 3DC79761.5020607@mega-bucks.co.jp
обсуждение исходный текст
Ответы Re: executing delete in a case statement?  (Richard Huxton <dev@archonet.com>)
Re: executing delete in a case statement?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-general
What is the proper way to execute a delete statement (if possible) in a
case statement. I am trying various versions of the following but can't
get it to work:

"select member_id, case when (select count(buy_later) from cart_li where
member_id=cart_id AND buy_later=true) > 0 then (delete from cart_li
where cart_id=10) end from carts"

Thanks!

Jc


В списке pgsql-general по дате отправления:

Предыдущее
От: frbn
Дата:
Сообщение: Re: PostgreSQL for Windows 2000
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: executing delete in a case statement?