Re: Bit Mapping operation
От | Philip Hallstrom |
---|---|
Тема | Re: Bit Mapping operation |
Дата | |
Msg-id | 20010612140315.A45875-100000@oddjob.adhesivemedia.com обсуждение исходный текст |
Ответ на | Bit Mapping operation (Najm Hashmi <najm@flipr.com>) |
Список | pgsql-sql |
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 > > >
В списке pgsql-sql по дате отправления: