From: | C F <tacnaboyz(at)yahoo(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | SQL Help |
Date: | 2003-05-30 15:47:03 |
Message-ID: | 20030530154703.37238.qmail@web20415.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hello,
I already tried this same basic question with no response.... maybe I was too wordy. So here it is simplified.... what's the best way to write this query? I'm open to using stored procedures, but even then I don't know how I would conditionally populate a resultset (refcursor). Notice that in the first three cases, the expression is the exact same, only the return value is different. This seems inefficient....
select
(case when column1 = column2 then column3 end) as alias1,
(case when column1 = column2 then column4 end) as alias2,
(case when column1 = column2 then column5 end) as alias3,
(case when column6 = column7 then column8 end) as alias4
from
mytable
;
Any ideas?
Thanks!
---------------------------------
Do you Yahoo!?
Free online calendar with sync to Outlook(TM).
From | Date | Subject | |
---|---|---|---|
Next Message | David Klugmann | 2003-05-30 16:02:07 | SELECT statement within libpq |
Previous Message | Jr. | 2003-05-30 14:38:36 | Re: "record" datatype - plpgsql |