Re: Type resolution for operators - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Type resolution for operators
Date
Msg-id Pine.LNX.4.21.0011081750400.1138-100000@peter.localdomain
Whole thread Raw
In response to Type resolution for operators  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
Responses Re: Type resolution for operators
List pgsql-hackers
Thomas Lockhart writes:

> (and returns 'false'). To force these to be handled as integers, prefix
> one with the "int" type specifier:
> 
>   select int '1' = '01';
> 
> which, btw, returns 'true'.

Uh, how can an integer be equal to a character value?  Where did the type
system go?

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Unhappy thoughts about pg_dump and objects inherited from template1
Next
From: Tom Lane
Date:
Subject: Re: Type resolution for operators