Regression in 8.3? - Mailing list pgsql-general

From Patric Bechtel
Subject Regression in 8.3?
Date
Msg-id 47379472.3080102@googlemail.com
Whole thread Raw
Responses Re: Regression in 8.3?  (Michael Glaesemann <grzm@seespotcode.net>)
Re: Regression in 8.3?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List 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-----

pgsql-general by date:

Previous
From: Christian Schröder
Date:
Subject: Re: (Never?) Kill Postmaster?
Next
From: Michael Glaesemann
Date:
Subject: Re: Regression in 8.3?