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" <[email protected]>: > 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
