Change the conditions of other 3 queries, so those shall give empty row sets 
depending on your value.

29.12.2012, 23:06, "JORGE MALDONADO" <jorgemal1...@gmail.com>:
> I have a query similar to the one shown below but, depending on the value of 
> a field, only the first SELECT statement shoud execute and the other 3 should 
> be ignored. Is there a way to achieve this situation?
>
> SELECT fields FROM tblTable WHERE condition
> UNION
>
> SELECT fields FROM tblTable WHERE condition
>
> UNION
>
> SELECT fields FROM tblTable WHERE condition
> UNION
>
> SELECT fields FROM tblTable WHERE condition
>
> Respectfully,
> Jorge Maldonado


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to