In response to "c k" <[EMAIL PROTECTED]>: > Is there any control structure statement similar to select case ... ? If yes > how to use it. I have tried to use, case when <expression> then <expression> > end, but not worked well as I want to use other control structures and sql > statements to be executed for each case.
Personally, I don't understand the question. Perhaps if you provided an example of what you are trying to do with CASE WHEN and why it doesn't work for you. It _does_ sound like you need to be using something like pl/pgsql. -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ [EMAIL PROTECTED] Phone: 412-422-3463x4023 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
