On Tue, 12 Dec 2000, Tom Lane wrote:
TL> I can't duplicate the problem either. I tried:
TL>
TL> play=> select substring(cp from 1 for 4)::int4 from out2cp;
TL> ?column?
TL> ----------
TL> 3182
TL> 3182
TL> (2 rows)
TL>
TL> Does anyone else see a failure with this? If so what platform are you
TL> on, and what build of Postgres are you using?
Well, I'm running under RedHat Linux 6.x (ia-32) and now I don't
really recall for sure where did I take the RPM, but I think I
downloaded it from ftp.postgresql.org.
OK, tomorrow I'll do some more tests to see where the problem lies
(you know, intranet-homed machine not accessible from public Internet).
Bye Borek
--
=====================================================================
BOREK LUPOMESKY Usti nad Labem, Czech Republic, Europe
WWW: http://www.volny.cz/borekl/ PGP keyid: B6A06AEB
==========[ MIME/ISO-8859-2 & PGP encrypted mail welcome ]===========