Re: Like vs '=' bug with indexing

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Like vs '=' bug with indexing
Дата
Msg-id 8360.981350431@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Like vs '=' bug with indexing  (Hannu Krosing <hannu@tm.ee>)
Список pgsql-hackers
Hannu Krosing <hannu@tm.ee> writes:
> Also I remember being told that bytea _can_ hold embedded \0, no ?

Yes.  What has that got to do with text et al?

>> Possibly chr() should reject chr(0) ...
>
> there is no function chr() at least in 7.0.2. 

I think it used to be called ichar(), but then someone pointed out that
Oracle calls it chr().

> and char is not usable from psql (gives out strange errors);

char(n) is a type name, not a function call.
        regards, tom lane


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

Предыдущее
От: "Mitch Vincent"
Дата:
Сообщение: Re: Very odd order by behavior - followup
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Foreign Key Columns And Indices