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: | Raw Message | Whole Thread | 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? |