| From: | Patric Bechtel <patric(dot)bechtel(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Regression in 8.3? |
| Date: | 2007-11-11 23:46:58 |
| Message-ID: | 47379472.3080102@googlemail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
just compiled a fresh 8.3 on my Ubuntu Gutsy, but there's one thing
which seems to have changed though I cannot get any hint about that in
the docs:
Given a table bla(a bigint,b text)
select * from bla where a like '8%'
works in <=8.2, but not on 8.3
Same happens with date columns, too.
I know I can workaround by casting to text, but I thought the server
would be intelligent enough to use a simple string conversion in that
case on its own (like it did all the years before already...)
tia,
Patric
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: GnuPT 2.5.2
iD8DBQFHN5RyfGgGu8y7ypARAvF+AJ9Z+BMFi/KrYzNQ4H1vW//x5gtE4ACguISW
JB3IsHmd0hqldhafEGFcRDQ=
=orlu
-----END PGP SIGNATURE-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Glaesemann | 2007-11-11 23:52:18 | Re: Regression in 8.3? |
| Previous Message | Christian Schröder | 2007-11-11 20:49:07 | Re: (Never?) Kill Postmaster? |