Re: BUG #4114: Inconsistent shift operator

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4114: Inconsistent shift operator
Date: 2008-04-20 19:02:53
Message-ID: 20080420190253.GP6870@frubble.xen.chris-lamb.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Sun, Apr 20, 2008 at 08:17:50PM +0200, Zdenek Kotala wrote:
> Roman Kononov napsal(a):
> >The below test cases show the obvious inconsistency between different
> >integer types.
>
> It seems to be OK regarding how C shift operator works. Try

Yes, but I interpret this behaviour as not being very useful for people
writing SQL code that uses the shift operators. C is a very low level
language and you almost always end up writing platform specific code,
SQL is supposed to be much higher level and should abstract away system
specific differences.

I've not been able to think of a nice way of doing this though.

Sam

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Buk 2008-04-21 01:58:45 BUG #4119: Add foreign key fails for non-presence of a record that does exist.
Previous Message Sam Mason 2008-04-20 18:58:59 Re: Inconsistent shift operator