Re: [SQL] CASE returning multiple values (was SQL Help)

2003-05-31 Thread Richard Huxton
On Friday 30 May 2003 4:47 pm, C F wrote: > Hello, > I already tried this same basic question with no response maybe I was > too wordy. I think it's more a case of nobody seeing a better way. > select > (case when column1 = column2 then column3 end) as alias1, > (case when column1 = colu

Re: [SQL] CASE returning multiple values (was SQL Help)

2003-05-31 Thread Tom Lane
Richard Huxton <[EMAIL PROTECTED]> writes: > On Friday 30 May 2003 4:47 pm, C F wrote: >> 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 colum

Re: [SQL] CASE returning multiple values (was SQL Help)

2003-05-31 Thread C F
I was afraid someone was going to ask that :) Okay, I'll do my best at explaining where I'm coming from I'm working on a mapping application it is user-configurable.  What this means (as it pertains to this disucssion) is that the through a configuration file, the user is able to define the ru

Re: [SQL] CASE returning multiple values (was SQL Help)

2003-06-02 Thread Richard Huxton
On Friday 30 May 2003 7:01 pm, C F wrote: > I was afraid someone was going to ask that :) > Okay, I'll do my best at explaining where I'm coming from [snip long but detailed description I asked for -thanks] Right - I've done something similar to this before, and I ended up building my SQL on