Re: Can someone else verify if this is a bug?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Can someone else verify if this is a bug?
Дата
Msg-id 6386.1188055220@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Can someone else verify if this is a bug?  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
Список pgsql-general
Дерево обсуждения 
Tony Caduto <tony_caduto@amsoftwaredesign.com> writes:
> Basically if you have a function in your view SQL like this:

> replace(address1, '\r', '')

> pg_get_viewdef is returning the view definition with the \r replaced by
> it's ASCII code which causes this:

> replace(address1, '
> ','')

This is not incorrect, if the original was interpreted under
escape-string syntax.  Perhaps you meant to type \\r ?

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Bigtime scaling of Postgresql (cluster and stuff I suppose)
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: [PERFORM] Partioning tsearch2 a table into chunks and accessing via views