Re: [HACKERS] New INET and CIDR types
| От | Thomas G. Lockhart |
|---|---|
| Тема | Re: [HACKERS] New INET and CIDR types |
| Дата | |
| Msg-id | 36373602.D580E67F@alumni.caltech.edu обсуждение исходный текст |
| Ответ на | Re: [HACKERS] New INET and CIDR types (darcy@druid.net (D'Arcy J.M. Cain)) |
| Ответы |
Re: [HACKERS] New INET and CIDR types
|
| Список | pgsql-hackers |
> What kind of things are you looking for? I thought I had most
> possibilities covered in the tests I sent.
The original test loaded a table and displayed the results. I'd like to
see some queries which exercise the operators associated with the types.
In this case, that may just be comparison operators, but if you have
math operators we should exercise those too. And any other conversion
operations, such as converting back and forth from int4, if that is
allowed.
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';
would be interesting.
- Tom
В списке pgsql-hackers по дате отправления: