|
Hello everyone 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
|
BEGIN:VCARD VERSION:2.1 N:Sjöberg;Mats FN:Mats Sjöberg ORG:Cybernetics Business Decisions AB TEL;WORK;VOICE:3921 TEL;CELL;VOICE:0706 54 07 68 ADR;WORK:;;Rännilstäppan;ÅKERSBERGA;;184 91;SWEDEN LABEL;WORK;ENCODING=QUOTED-PRINTABLE:R=E4nnilst=E4ppan=0D=0A=C5KERSBERGA 184 91=0D=0ASWEDEN EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20040302T073452Z END:VCARD
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
