0

Pardon this post here as I didn't see any Postgres forum.

I have a table with a 16 length bit value.

Can someone please help me how I do the where clause on my select?

example data for that field

0000000000000001
0000000000000011
0000000000000010

how would I select one of the 3 above?

select * from surcharge_table_fd where market_type_bit_value = 1

Edited by mike_2000_17: Fixed formatting

1
Contributor
1
Reply
2
Views
8 Years
Discussion Span
Last Post by kireol
0

nevermind. figured it out

select * from surcharge_table_fd where (market_type_bit_value & '0000000000000010')::int <> 0
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.