| 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: | Whole Thread | Raw Message | 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 |