Re: Casting on the limit

From: Ottó Havasvölgyi <havasvolgyi(dot)otto(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Casting on the limit
Date: 2008-01-21 08:13:41
Message-ID: 34608c0c0801210013r18c98721me71199c87b97f604@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

But 8.2.6 works the same. I have just upgraded.

2008/1/21, Ottó Havasvölgyi <havasvolgyi(dot)otto(at)gmail(dot)com>:
> Sorry, version is 8.2.4
>
> 2008/1/21, Ottó Havasvölgyi <havasvolgyi(dot)otto(at)gmail(dot)com>:
> > Hi,
> >
> > In 8.2.5:
> >
> > This does not work (out of range):
> > select -32768::int2
> >
> > But this works:
> > select cast(-32768 as int2);
> >
> > What is the difference between the two syntax in the background? I
> > always thought they are the same.
> >
> > Best regards,
> > Otto
> >
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Adriaan van Os 2008-01-21 08:17:47 BUG #3891: Multiple UPDATE doesn't handle UNIQUE constraint correctly
Previous Message Ottó Havasvölgyi 2008-01-21 08:06:34 Re: Casting on the limit