On 07/11/2018 08:02 AM, Takao Magoori wrote:
Hello,
I have a table which has billions of rows and I want to select it by
bitwise operation like,
=# CREATE TABLE IF NOT EXISTS t_bitwise (
id INTEGER NOT NULL
,status_bigint BITINT NOT NULL
,status_bit BIT(32) NOT NULL
);
=# INSERT IN
Hello,
I have a table which has billions of rows and I want to select it by
bitwise operation like,
=# CREATE TABLE IF NOT EXISTS t_bitwise (
id INTEGER NOT NULL
,status_bigint BITINT NOT NULL
,status_bit BIT(32) NOT NULL
);
=# INSERT INTO t_bitwise (id, status_bigint, status_bit) SELECT