On Aug 11, 2016, at 2:11 PM, Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> 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