Re: Like vs '=' bug with indexing

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hannu Krosing <hannu(at)tm(dot)ee>
Cc: m w <mttf2000(at)yahoo(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Like vs '=' bug with indexing
Date: 2001-02-05 05:20:31
Message-ID: 8360.981350431@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hannu Krosing <hannu(at)tm(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Karel Zak 2001-02-05 07:02:49 Re: julian day function
Previous Message Mitch Vincent 2001-02-05 04:05:13 Re: Very odd order by behavior - followup