Re: PostgreSQL specific datatypes very confusing for beginners who use wrappers around JDBC

Oh. The CREATE CAST command. Wow, I was totally unaware of this entire
feature!

On Tue, Jan 28, 2014 at 3:36 PM, Mike Christensen <mike(at)kitchenpc(dot)com>wrote:

> How do you create casts in Postgres?
>
>
> On Tue, Jan 28, 2014 at 3:24 PM, Andrew Sullivan <ajs(at)crankycanuck(dot)ca>wrote:
>
>> On Tue, Jan 28, 2014 at 02:55:03PM -0800, Mike Christensen wrote:
>>
>> > I'd be curious as to what types of bugs were caused by these implicit
>> > casts..
>>
>> Typically, they were cases when there was an ambiguity that the
>> programmer didn't understand, causing applications to blow up in
>> surprising and wonderful ways.
>>
>> There are things you can do if you're really prepared for the gun
>> aimed at your feet. Since you can create casts in Postgres, you can
>> actually add back many of the implicit casts yourself.
>>
>> > Such as implicitly cast iff the intention is not ambiguous
>>
>> I think if the developers could write code that read minds, they'd be
>> working on more profitable enterprises ;-)
>>
>> Best,
>>
>> A
>>
>> --
>> Andrew Sullivan
>> ajs(at)crankycanuck(dot)ca
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>
>