Re: SELECT CAST(123 AS char) -> 1 - Mailing list pgsql-general

From Ken Johanson
Subject Re: SELECT CAST(123 AS char) -> 1
Date
Msg-id 47B31AF5.8030108@kensystem.com
Whole thread Raw
In response to Re: SELECT CAST(123 AS char) -> 1  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: SELECT CAST(123 AS char) -> 1
List pgsql-general
Alvaro Herrera wrote:
> 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.
>

Agreed. There may be allot of users who in the case of CAST, need to
extract the leftmost digit, and for those database and their users that
do this by default, it would cause harm.



pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: SELECT CAST(123 AS char) -> 1
Next
From: Alvaro Herrera
Date:
Subject: Re: SELECT CAST(123 AS char) -> 1