Varying bit field: to set and query a particular bit

Поиск
Список
Период
Сортировка
От S P Arif Sahari Wibowo
Тема Varying bit field: to set and query a particular bit
Дата
Msg-id Pine.LNX.4.42.0112130944500.15260-100000@macbeth.tirone.com
обсуждение исходный текст
Список pgsql-sql
Hi!

Do you know what is the most efficient way to replace (set/unset) a
certain bit in a varying bit field (dynamic length), and what is the most
efficient way to query the value of a certain bit in a varying bit field?

Right now the easiest way seems to use substring function, but this
function apparently will use a lot of expensive bit shifting. 
Is there any better way?

Unfortunately the AND and OR operation require the bits have same length.  
Is there any way to AND or OR two bit string with different length?
Is there any way to extend the length of a bit string to a specified 
length?

Thank you.

--                                   S P Arif Sahari Wibowo _____  _____  _____  _____ /____  /____/ /____/ /____
  arifsaha@yahoo.com
 
_____/ /      /    / _____/       http://www.arifsaha.com/



В списке pgsql-sql по дате отправления:

Предыдущее
От: David Stanaway
Дата:
Сообщение: Re: cidr question (resent)
Следующее
От: MindTerm
Дата:
Сообщение: performance tuning in large function / transaction