Re: [HACKERS] Automatic type conversion

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: Postgres Hackers List <hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] Automatic type conversion
Date: 1998-04-05 14:46:57
Message-ID: 35279961.CF1532B9@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On to target type matching...

Ooh. This one was easy, apparently:

tgl=> create table test (s smallint);
CREATE

Old behavior:
tgl=> insert into test select 1 + 2;
ERROR: parser: attribute 's' is of type 'int2' but expression is of
type 'int4'

New behavior:
tgl=> insert into test select 1 + 2;
INSERT 18432 1
tgl=> select * from test;
s
-
3
(1 row)

Back to fixing broken stuff in operators...

- Tom

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Ivar Helbekkmo 1998-04-05 15:41:40 Re: [HACKERS] Open 6.3.1 issues
Previous Message Bruce Momjian 1998-04-05 14:30:33 Re: [HACKERS] Open 6.3.1 issues