Re: SELECT CAST(123 AS char) -> 1

Ken Johanson wrote:

> Henceforth SELECT CAST(123 AS char) will and should undisputedly return '1'.

If you are arguing that the spec's definition of the CHARACTER type is
not really very useful, I think you are going to find a lot of
supporters.  You can send your complaints to the SQL committee; but
then, it is unlikely that this is going to change anytime soon because
of the fear of breaking backwards compatibility.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.