Richard Huxton wrote:
>
> You could write a set-returning function that takes either:
> 1. A list of conditions
> 2. The text for a WHERE clause
> If it gets no conditions or a blank string, it returns nothing.
> You will need to create the function with SECURITY DEFINER permissions,
>
That's a very good suggestion. I've just red about SECURITY DEFINER...
great.
Thanks
--
View this message in context: http://old.nabble.com/kind-of-RULE-on-SELECT-depending-on-existence-of-a-WHERE-condition-tp27741669p27753818.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.