Re: dynamic table naming in function

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: dynamic table naming in function
Дата
Msg-id 20051029181408.GA14086@wolff.to
обсуждение исходный текст
Ответ на dynamic table naming in function  (Matthew Peter <survivedsushi@yahoo.com>)
Список pgsql-general
On Sat, Oct 29, 2005 at 10:45:21 -0700,
  Matthew Peter <survivedsushi@yahoo.com> wrote:
> Out of curiosity, I was wondering if it is possible to
> use dynamic table names in a function? AND whether or
> not you can test a value prior to insert to see
> whether or not you want to update that column. Where
> you could pass in the name of the table for it use ANY
> name passed in rather than statically defining it.

You can use the EXECUTE statement to do this kind of thing.

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

Предыдущее
От: Matthew Peter
Дата:
Сообщение: dynamic table naming in function
Следующее
От: Tom Lane
Дата:
Сообщение: Re: dynamic table naming in function