Using Postgres syntax, I've found a couple situations where valid dollar quote syntax is not parsed correctly.
One is that dollar quotes do not seem to be respected in COMMENT statements:
COMMENT ON SCHEMA "my_schema"
IS $$My Schema Comment$$;
Based on my read of the Postgres docs, I would assume dollar-quoted strings are valid anywhere regular strings are. I'm not sure what other situations this would pop up in, but it might not be an issue particular to comment statements.
The other is that the optional tags do not seem to be supported. For example, this works:
CREATE FUNCTION foo(TEXT)
RETURNS BOOLEAN
LANGUAGE SQL
AS $$
RETURN TRUE
$$;
But this equivalent function does not:
CREATE FUNCTION foo(TEXT)
RETURNS BOOLEAN
LANGUAGE SQL
AS $function$
RETURN TRUE
$function$;
Using Postgres syntax, I've found a couple situations where valid dollar quote syntax is not parsed correctly.
One is that dollar quotes do not seem to be respected in
COMMENT
statements:Based on my read of the Postgres docs, I would assume dollar-quoted strings are valid anywhere regular strings are. I'm not sure what other situations this would pop up in, but it might not be an issue particular to comment statements.
The other is that the optional tags do not seem to be supported. For example, this works:
But this equivalent function does not: