In a table i have a column status of type bigint.
I need to create a view of the table including all rows with bit 4 set (value 8).
At the same time i need to exclude excludig all rows with bit 2 set.
What is the syntax to extract those bits?
I have tested get_bit(string, offset) but this requires a string, and not a bigint.
Is there a function to
Best regards, Mats
pgsql-sql by date
|Next:||From: Mike Rylander||Date: 2004-05-12 12:17:39|
|Subject: Re: How do i extract a certain bit from a bigint column|
|Previous:||From: William Anthony Lim||Date: 2004-05-12 10:19:45|
|Subject: Re: working with schema|