Re: binary operators on integers

From: Marko Kreen <marko(at)l-t(dot)ee>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-patches(at)postgresql(dot)org
Subject: Re: binary operators on integers
Date: 2001-01-20 15:31:28
Message-ID: 20010120173127.A10475@l-t.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

On Fri, Jan 19, 2001 at 04:30:09PM -0500, Bruce Momjian wrote:
> Looks like this is fixed:
>
> test=> select 5 & ~ 6;
> ERROR: Unable to identify a right operator '&' for type 'int4'
> You may need to add parentheses or an explicit cast
> test=> select 5 & (~ 6);
> ?column?
> ----------
> 1
> (1 row)

I can still reproduce it:

marko=# SELECT 5 & ~6;
ERROR: Unable to identify a right operator '&' for type 'int4'
You may need to add parentheses or an explicit cast

Or did you mean it can be fixed with parenthesis? That was the
case from the beginning.

>
> > This patch was installed, with xor as "#". The parser still needs work.
> > Besides the known issue of "|", this also parses funny:
> >
> > => select 5 & ~ 6;
> > ERROR: Unable to identify a right operator '&' for type 'int4'
> >

--
marko

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marko Kreen 2001-01-20 15:53:37 status of 64bit ints? was: Re: Transaction ID wraparound: problem and proposed solution
Previous Message Magnus Hagander 2001-01-20 13:28:45 Postgresql on win32

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2001-01-20 18:31:49 Re: [PATCHES] binary operators on integers
Previous Message Bruce Momjian 2001-01-19 21:30:09 Re: binary operators on integers