On Tuesday 30 March 2010 4:59:30 pm Jeff Davis wrote: > On Tue, 2010-03-30 at 16:32 -0700, Adrian Klaver wrote: > > 8.3 tightened up type casting. You cannot INSERT a '0' without casting it > > to an integer i.e '0'::integer. > > I don't think that's accurate: > > postgres=# select version(); > > version > > --------------------------------------------------------------------------- >----------------------------------------- -- > PostgreSQL 9.0devel on x86_64-unknown-linux-gnu, compiled by GCC > gcc-4.3.real (Ubuntu 4.3.2-1ubuntu12) 4.3.2, 64-bit > (1 row) > > postgres=# create table ints(i int); > CREATE TABLE > postgres=# insert into ints values('0'); > INSERT 0 1 > > > Regards, > Jeff Davis My mistake. I could of swore I had problems with this when I first tried 8.3. What happens when you rely on memory. -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general