John Engelhart wrote:
> When this piece of code is wrapped fully inside a /* */ style comment block,
> the parser interprets the */ inside the substring() function as the end of
> comment. 'Expected' behavior (principle of least astonishment, at least) is
> that the .*/ part inside the substring function not trigger the end of
> comments.
The SQL standard does not provide for this kind of exception, so there
is no real use in discussing it.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/