On Aug 11, 2016, at 2:11 PM, Jim Nasby <[email protected]> wrote:
> CREATE FUNCTION pg_temp.is() RETURNS text LANGUAGE sql AS $$SELECT
> 'x'::text$$;
> SELECT 'x'||is();
> ERROR: syntax error at or near "("
> LINE 1: SELECT 'x'||is();
>
> I was finally able to figure out this was because "is" needs to be quoted; is
> there a way this could be hinted?
>
> FWIW, the real-world case here comes from using pgTap, which has an is()
> function. I've used that countless times by itself without quoting, so it
> never occurred to me that the syntax error was due to lack of quotes.
Why does it need quotation marks in this case?
D
smime.p7s
Description: S/MIME cryptographic signature
