In 7.1 it's there... using the |(or) &(and), etc.. operators. In 7.0.3
it's not although can be added easily.
example:
test=> select 2 | 1;
?column?
----------
3
(1 row)
test=> select 2 & 1;
?column?
----------
0
(1 row)
test=> select 3 & 1;
?column?
----------
1
(1 row)
test=>
On Mon, 11 Jun 2001, Najm Hashmi wrote:
> Hi all, I am just wondering if bit map operations are possible in
> pl/pgsql. We are storing sixteen different (one or many ... i.e. check
> boxes ) choices in a small int. For data cruchinging reasons, we need
> to reverse the process to find out what what fields where selected or
> checked. Is this info somewhere in the docs?
> Thanks in advance.
> Regards,
>
> --
> Najm Hashmi
> Tel:514-271-9791
> www.mondo-live.com
> www.flipr.com
>
>
>
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
