Dollaw sign quoting disabled

Поиск
Список
Период
Сортировка
От snappingturtle
Тема Dollaw sign quoting disabled
Дата
Msg-id 1164242042.629558.126570@f16g2000cwb.googlegroups.com
обсуждение исходный текст
Ответы Re: Dollaw sign quoting disabled  (Bricklen Anderson <banderson@presinet.com>)
Re: Dollaw sign quoting disabled  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Список pgsql-general
It appears that in my installation of Postgres that dollaw sign quoting
is disabled.  For example, the following command returns an error:

 CREATE or replace FUNCTION add_em(int, int) RETURNS integer AS $$
     SELECT $1 + $2;
 $$ LANGUAGE SQL;

The error:

 psql:borman.sql:6: ERROR:  syntax error at or near "$" at character 72
 psql:borman.sql:7: ERROR:  syntax error at or near "$" at character 1

Putting something between the dollar signs (e.g. $FUNCTION$) produces
the same error. Using regular quotes works, however:

 CREATE or replace FUNCTION add_em(int, int) RETURNS integer AS '
     SELECT $1 + $2;
 ' LANGUAGE SQL;

 CREATE FUNCTION

I didn't do anything (that I know of) to disable dollar quoting.  Any
advice on how to enable dollar sign quoting?


В списке pgsql-general по дате отправления:

Предыдущее
От: Ragnar
Дата:
Сообщение: Re: IN clause
Следующее
От: sasan3@gmail.com
Дата:
Сообщение: PGDATA