From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Patric Bechtel <patric(dot)bechtel(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Regression in 8.3? |
Date: | 2007-11-13 05:27:36 |
Message-ID: | 20071113052736.GB4042@depesz.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Nov 12, 2007 at 05:18:28PM -0500, Tom Lane wrote:
> regression=# select '00123'::text like '0%';
> ?column?
> ----------
> t
> (1 row)
> regression=# select '00123'::int4 like '0%';
> ?column?
> ----------
> f
> (1 row)
i think it's definitelly ok - '00123'::text is *not equal* to
'00123'::int4. so result of "like'ing" it is not necessarily the same.
what's more - in case patric showed - when he had int column there was
no "danger" of '00123'::int4.
best regards,
depesz
--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA. here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2007-11-13 05:38:05 | Re: PITR and warm standby setup questions |
Previous Message | Greg Smith | 2007-11-13 05:07:55 | Re: PITR and warm standby setup questions |