Re: what's the scope of psql parameter values?

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: what's the scope of psql parameter values?
Дата
Msg-id m3wueg281a.fsf@varsoon.wireboard.com
обсуждение исходный текст
Ответ на what's the scope of psql parameter values?  ("Dick Wieland" <dick.wieland@wiline.com>)
Список pgsql-general
"Dick Wieland" <dick.wieland@wiline.com> writes:

> wiline=# select :S.isf('update');
> WARNING:  Error occurred while executing PL/pgSQL function isf
> WARNING:  line 6 at select into variables
> ERROR:  parser: parse error at or near ":" at character 22
>
> Is this expected behavior I wonder?  Does the parameter substitution
> facility not extend down "into" the function space ...

The function body is just a single-quoted SQL string as far as psql is
concerned, and it doesn't do variable substitution inside quoted
strings.

-Doug

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: We need volunteers for Comdex!
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: We need volunteers for Comdex!