Re: what's the scope of psql parameter values? - Mailing list pgsql-general

From Doug McNaught
Subject Re: what's the scope of psql parameter values?
Date
Msg-id m3wueg281a.fsf@varsoon.wireboard.com
Whole thread Raw
In response to what's the scope of psql parameter values?  ("Dick Wieland" <dick.wieland@wiline.com>)
List 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 by date:

Previous
From: Josh Berkus
Date:
Subject: We need volunteers for Comdex!
Next
From: Josh Berkus
Date:
Subject: Re: We need volunteers for Comdex!