executing delete in a case statement? - Mailing list pgsql-general

From Jean-Christian Imbeault
Subject executing delete in a case statement?
Date
Msg-id 3DC79761.5020607@mega-bucks.co.jp
Whole thread Raw
Responses 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>)
List 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 by date:

Previous
From: frbn
Date:
Subject: Re: PostgreSQL for Windows 2000
Next
From: Richard Huxton
Date:
Subject: Re: executing delete in a case statement?