Re: Backslash as ordinary char vs. not; set via a connection/session

Поиск
Список
Период
Сортировка
От Ken Johanson
Тема Re: Backslash as ordinary char vs. not; set via a connection/session
Дата
Msg-id 44C92CCA.7000107@kensystem.com
обсуждение исходный текст
Ответ на Re: Backslash as ordinary char vs. not; set via a connection/session  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Список pgsql-general
Stefan Kaltenbrunner wrote:
> foo=# create table backslash(baz text);
> CREATE TABLE
> foo=# set standard_conforming_strings to on;
> SET
> foo=# insert into backslash values ('\\');
> INSERT 0 1
> foo=# set standard_conforming_strings to off;
> SET
> foo=# insert into backslash values ('\\');
> WARNING:  nonstandard use of \\ in a string literal
> LINE 1: insert into backslash values ('\\');
>                                       ^
> HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
> INSERT 0 1
> foo=# select * from backslash;
>  baz
> -----
>  \\
>  \
> (2 rows)
>
>
> like that ? :-)
>
>


Yes - that is the eye candy I'm looking for. Anxiously looking forward
to 8.2 :-)

ken



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Using an alternate PGDATA on RHEL4 with SELinux enabled
Следующее
От: "Shoaib Mir"
Дата:
Сообщение: Re: Permissions to connect to postgres database