Re: [HACKERS] New INET and CIDR types

Thus spake Thomas G. Lockhart
> So, things like (don't know if this exact example is sensible):
>
> select '' as count, c as cidr from inet_tbl
> where c < '128.149.50' and c > '128.149';

Of course. I only sent in tests for the functions I added. Ok, add
the following two INSERT statements.

INSERT INTO INET_TBL (c, i) VALUES ('10', '11.1.2.3/8');
INSERT INTO INET_TBL (c, i) VALUES ('10', '9.1.2.3/8');

Then add the following query.

SELECT i, c,
i < c AS lt, i <= c AS le, i = c AS eq,
i >= c AS ge, i > c AS gt, i <> c AS ne,
i << c AS sb, i <<= c AS sbe, i >> c AS sup, i >>= c AS spe
FROM INET_TBL;

--
D'Arcy J.M. Cain <darcy(at){druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 424 2871 (DoD#0082) (eNTP) | what's for dinner.