-----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----- ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
