Re: kind of RULE on SELECT depending on existence of a WHERE condition

Поиск
Список
Период
Сортировка
От rawi
Тема Re: kind of RULE on SELECT depending on existence of a WHERE condition
Дата
Msg-id 27753818.post@talk.nabble.com
обсуждение исходный текст
Ответ на Re: kind of RULE on SELECT depending on existence of a WHERE condition  (Richard Huxton <dev@archonet.com>)
Список pgsql-sql

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.



В списке pgsql-sql по дате отправления:

Предыдущее
От: Petru Ghita
Дата:
Сообщение: Re: Create functions using a function
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: kind of RULE on SELECT depending on existence of a WHERE condition