Re: [SQL] Logical and for int4?

From: Chris Griffin <cgriffin(at)websales(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: [SQL] Logical and for int4?
Date: 1999-12-03 03:16:58
Message-ID: B46C7629.11D9%cgriffin@websales.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


I wrote a c routine to 'and' to integers. I defined a function the defined
the '&' operator. So now I can do the following:

where (int_field & int_mask) <> 0 ....

I turned out to be much easier that I expected. If anyone is interested in
this or possibly other function/operators let me know.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Andy Lewis 1999-12-03 03:56:52 Another Date question
Previous Message Tom Lane 1999-12-02 23:32:59 Re: [SQL] How to avoid "Out of memory" using aggregate functions?