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@gmail.com