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?
Re: executing delete in a case statement?
Список 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 по дате отправления: