Regression in 8.3?

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-----

Responses

Browse pgsql-general by date

  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?