Re: Like vs '=' bug with indexing - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Like vs '=' bug with indexing
Date
Msg-id 8360.981350431@sss.pgh.pa.us
Whole thread Raw
In response to Re: Like vs '=' bug with indexing  (Hannu Krosing <hannu@tm.ee>)
List 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 by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Re: Very odd order by behavior - followup
Next
From: Stephan Szabo
Date:
Subject: Re: Foreign Key Columns And Indices