"Altaf Malik" <mmalik_altaf(at)yahoo(dot)com> writes:
> I think $$ should start a quote instead of $x$. Or $ character have special
> meaning but if there is one dollar does not happen anything wrong. Are $$ and
> $x$ equal? If yes, what happens with the character(s) between the two dollar
> signs?
$anything$ starts a quote and ends with $anything$ as in:
postgres=# select $foo$bar$foo$;
?column?
----------
bar
(1 row)
However the $ must start a new token:
postgres=# select foo$foo$bar$foo$;
ERROR: column "foo$foo$bar$foo$" does not exist
LINE 1: select foo$foo$bar$foo$;
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com