Re: [HACKERS] Automatic type conversion - Mailing list pgsql-hackers

From Thomas G. Lockhart
Subject Re: [HACKERS] Automatic type conversion
Date
Msg-id 35279961.CF1532B9@alumni.caltech.edu
Whole thread Raw
In response to Automatic type conversion  ("Thomas G. Lockhart" <lockhart@alumni.caltech.edu>)
List 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

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] Re: [HACKERS] Everything leaks; How it mm suppose to work?
Next
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] On improving OO support in posgresql and relaxing oid bottleneck at the same time