Re: Bitwise operators in SQL

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Arcady Genkin <a(dot)genkin(at)utoronto(dot)ca>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Bitwise operators in SQL
Date: 2001-05-25 18:12:22
Message-ID: Pine.LNX.4.30.0105252012000.758-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Arcady Genkin writes:

> But the problem is that there are no
> bitwise operators among Postgres's supported operators. So, I cannot
> write something like
>
> select name from pages where access&2>0;
>
> Is there a standard way to approach this kind of problem?

Upgrading.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2001-05-25 18:13:43 Re: [GENERAL] Compilation fails --with-ssl on Solaris 8
Previous Message Richard Huxton 2001-05-25 17:31:07 Re: [URGENT] How to generata a unique string id