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