Re: [HACKERS] Interesting behaviour ! - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: [HACKERS] Interesting behaviour !
Date
Msg-id 378D7C74.99700FF7@alumni.caltech.edu
Whole thread Raw
In response to RE: [HACKERS] Interesting behaviour !  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Responses RE: [HACKERS] Interesting behaviour !
List pgsql-hackers
> Each type has a typeinput(char * => type ) proc and a typeoutput(
> type -> char *) proc.
> Doesn't int2in(int4out()) convert int4 to int2 ?
> However,typeinput proc causes elog(ERROR) in most cases if it
> couldn't convert correctly.

Conversion using an intermediate string is possible, but not the
preferred technique.

The "automatic type coersion" code, used earlier in the parser, uses
the convention that any single-argument function taking the source
type as input and with the same name as the target type can be used
for type conversion. For example, the function int4(int2) would
convert int2 to int4. There are now routines in the parser for
choosing conversion strategies and for finding candidates, and these
could be reused for similar purposes when trying to match index
arguments.
                 - Thomas

-- 
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California


pgsql-hackers by date:

Previous
From: Adriaan Joubert
Date:
Subject: Re: [HACKERS] header files for spi.h/trigger.h]
Next
From: Zeugswetter Andreas IZ5
Date:
Subject: Re: [HACKERS] Re: Arrays versus 'type constant' syntax