Re: Query execution based on a condition - Mailing list pgsql-sql

From msi77
Subject Re: Query execution based on a condition
Date
Msg-id 2795691356809816@web15e.yandex.ru
Whole thread Raw
In response to Query execution based on a condition  (JORGE MALDONADO <jorgemal1960@gmail.com>)
List pgsql-sql
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" <jorgemal1960@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
shoudexecute 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



pgsql-sql by date:

Previous
From: "David Johnston"
Date:
Subject: Re: Query execution based on a condition
Next
From: Adrian Klaver
Date:
Subject: Re: Query execution based on a condition