Re: trigger - dynamic WHERE clause

Поиск
Список
Период
Сортировка
Искать
От
Pavel Stehule
Тема
Re: trigger - dynamic WHERE clause
Дата
в 15:39:50
Msg-id
BANLkTi=duDhBAkHNXH4=zH0MQgvcTnN4iA@mail.gmail.com
Ответ на
trigger - dynamic WHERE clause (Tarlika Elisabeth Schmitz)
Список
Дерево обсуждения
trigger - dynamic WHERE clause Tarlika Elisabeth Schmitz <postgresql3@numerixtechnology.de>
Re: trigger - dynamic WHERE clause Pavel Stehule <pavel.stehule@gmail.com>
Re: trigger - dynamic WHERE clause Tarlika Elisabeth Schmitz <postgresql3@numerixtechnology.de> 
Hello

2011/5/22 Tarlika Elisabeth Schmitz :
> EXECUTE 'SELECT 1 FROM ' || TG_TABLE_NAME || ' WHERE ' || whereclause
> || ' FOR UPDATE;';
>
> I am generating the whereclause dynamically as the number of columns
> queried varies.
>
> Am I right in assuming that I cannot use EXECUTE ... USING in this
> scenario?
>

why not? You can use it - just USING has a fixed numbers of
parameters, so you should to use a arrays.

Regards

Pavel Stehule

> --
>
> Best Regards,
> Tarlika Elisabeth Schmitz
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
В списке pgsql-general по дате отправления
Предыдущее
От: John R Pierce
Дата:
Следующее
От: jun yang
Дата:
FAQ