Skip site navigation (1) Skip section navigation (2)

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:06:34
Message-ID: 34608c0c0801210006t6dcd3154j61a98f8780659f7f@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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

Responses

pgsql-bugs by date

Next:From: Ottó HavasvölgyiDate: 2008-01-21 08:13:41
Subject: Re: Casting on the limit
Previous:From: Ottó HavasvölgyiDate: 2008-01-21 08:04:48
Subject: Casting on the limit

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group