Re: [BUGS] session variable

Поиск
Список
Период
Сортировка
От miko@idocs.com (Miko O'Sullivan)
Тема Re: [BUGS] session variable
Дата
Msg-id db27ea77.0309131023.4b94ae6@posting.google.com
обсуждение исходный текст
Ответ на Re: [BUGS] session variable  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: [BUGS] session variable
Список pgsql-sql
pgman@candle.pha.pa.us (Bruce Momjian) wrote in message news:<200309032042.h83KgmJ24665@candle.pha.pa.us>...
> Yes, see the FAQ.  You have to use EXECUTE for temp table access in
> functions.

Unfortunately in the 7.2.x version I have available, EXECUTE does not
allow "select into".  The docs suggests a technique for using a FOR
loop to extract information from an EXECUTE, but the technique only
works for finite set of expected variables, not for arbitrary values.

Any suggestions on how to kludge this issue?  It would be of great
value to me if there were a way to set and retrieve just one global
variable that persists throughout a session, and which can be
retrieved from a function.


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

Предыдущее
От: David W Noon
Дата:
Сообщение: Re: how to get decimal to date form
Следующее
От: Kyle
Дата:
Сообщение: Trigger on view