diff options
| author | Bruce Momjian | 2001-06-13 21:09:00 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2001-06-13 21:09:00 +0000 |
| commit | d4a4d4c32608fd7c84aeab655072a7667e57c02a (patch) | |
| tree | 9c6fd6eff3b567c6a7603837ad946212cddbd7a2 /src/test | |
| parent | 82dc79702f527437d226680eea3b245ced2c3363 (diff) | |
Attached is a patch adding following functions:
inet(text), cidr(text): convert a text value into inet/cidr
set_masklen(inet): set masklen on the inet value
Patch also contains regression checks for these functions.
Alex Pilosov
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/inet.out | 19 | ||||
| -rw-r--r-- | src/test/regress/sql/inet.sql | 4 |
2 files changed, 23 insertions, 0 deletions
diff --git a/src/test/regress/expected/inet.out b/src/test/regress/expected/inet.out index 9c0beef363e..27f4e4e85ae 100644 --- a/src/test/regress/expected/inet.out +++ b/src/test/regress/expected/inet.out @@ -18,6 +18,9 @@ INSERT INTO INET_TBL (c, i) VALUES ('10', '9.1.2.3/8'); -- check that CIDR rejects invalid input: INSERT INTO INET_TBL (c, i) VALUES ('192.168.1.2/24', '192.168.1.226'); ERROR: invalid CIDR value '192.168.1.2/24': has bits set to right of mask +-- check that CIDR rejects invalid input when converting from text: +INSERT INTO INET_TBL (c, i) VALUES (cidr('192.168.1.2/24'), '192.168.1.226'); +ERROR: invalid CIDR value '192.168.1.2/24': has bits set to right of mask SELECT '' AS ten, c AS cidr, i AS inet FROM INET_TBL; ten | cidr | inet -----+----------------+------------------ @@ -135,3 +138,19 @@ SELECT '' AS ten, i, c, | 9.1.2.3/8 | 10.0.0.0/8 | t | t | f | f | f | t | f | f | f | f (10 rows) +-- check the conversion to/from text and set_netmask +select '' AS ten, set_masklen(inet(text(i)), 24) FROM INET_TBL; + ten | set_masklen +-----+------------------ + | 192.168.1.226/24 + | 192.168.1.226/24 + | 10.1.2.3/24 + | 10.1.2.3/24 + | 10.1.2.3/24 + | 10.1.2.3/24 + | 10.1.2.3/24 + | 10.1.2.3/24 + | 11.1.2.3/24 + | 9.1.2.3/24 +(10 rows) + diff --git a/src/test/regress/sql/inet.sql b/src/test/regress/sql/inet.sql index d91c3a0bbf0..6e59714fd9e 100644 --- a/src/test/regress/sql/inet.sql +++ b/src/test/regress/sql/inet.sql @@ -18,6 +18,8 @@ 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'); -- check that CIDR rejects invalid input: INSERT INTO INET_TBL (c, i) VALUES ('192.168.1.2/24', '192.168.1.226'); +-- check that CIDR rejects invalid input when converting from text: +INSERT INTO INET_TBL (c, i) VALUES (cidr('192.168.1.2/24'), '192.168.1.226'); SELECT '' AS ten, c AS cidr, i AS inet FROM INET_TBL; @@ -45,3 +47,5 @@ SELECT '' AS ten, i, c, i >> c AS sup, i >>= c AS spe FROM INET_TBL; +-- check the conversion to/from text and set_netmask +select '' AS ten, set_masklen(inet(text(i)), 24) FROM INET_TBL; |