Function in selection?

From: Dousak "May (Phoebus Apollonus)" <phoebus(at)email(dot)si>
To: pgsql-general(at)postgresql(dot)org
Subject: Function in selection?
Date: 2003-03-13 18:56:02
Message-ID: 1047581762.1827.29.camel@Grandis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, I want to make really advanced query and I'm not sure it's
possible... it would be "like that":

select A, B, C, D, E, F from TABLE_X ORDER BY D, C, E
if A==0 AND B!=0 {A=B*Z.TABLE_Y}
if A!=0 AND B==0 {B=A/Z.TABLE_Y}

OK, I don't really have problems with first line :), but how can I tell
him to select like the second and third line are telling it?
is that possible? :/

Tnx,

May

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2003-03-13 18:58:57 Re: unlock rows
Previous Message Neil Conway 2003-03-13 18:53:54 Re: PL/Java (was: stored procedures)