Thank you:) I didn't even thought of this case. I am a bit surprised that "::" has higher precedence than negation, but maybe it has some cause. Sorry for sending it to this list.
Best regards, Otto 2008/1/21, Heikki Linnakangas <[EMAIL PROTECTED]>: > Ottó Havasvölgyi wrote: > > 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. > > "select -32768::int2" is equal to "select -(32768::int2)", and 32768 > doesn't fit in an int2. > > -- > Heikki Linnakangas > EnterpriseDB http://www.enterprisedb.com > ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
