"Dick Wieland" <dick(dot)wieland(at)wiline(dot)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