diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2014-08-28 22:37:58 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2014-08-28 22:37:58 -0400 |
| commit | 6c40f8316ed38a92049784b3e3d3b514ed379b5a (patch) | |
| tree | 906ae853055c894e2e2fbdc6f6a71d02ebf6b36f /src/test/regress/expected/inet.out | |
| parent | ec544a65c9090bc9da11ea384d1369fd552ca8b0 (diff) | |
| download | postgresql-6c40f8316ed38a92049784b3e3d3b514ed379b5a.tar.gz | |
Add min and max aggregates for inet/cidr data types.
Haribabu Kommi, reviewed by Muhammad Asif Naeem
Diffstat (limited to 'src/test/regress/expected/inet.out')
| -rw-r--r-- | src/test/regress/expected/inet.out | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/src/test/regress/expected/inet.out b/src/test/regress/expected/inet.out index 008cc0b5dd..d58bf017b6 100644 --- a/src/test/regress/expected/inet.out +++ b/src/test/regress/expected/inet.out @@ -204,6 +204,18 @@ SELECT '' AS ten, i, c, | ::4.3.2.1/24 | ::ffff:1.2.3.4/128 | t | t | f | f | f | t | f | f | t | t | t (17 rows) +SELECT max(i) AS max, min(i) AS min FROM INET_TBL; + max | min +-------------+----------- + 10:23::ffff | 9.1.2.3/8 +(1 row) + +SELECT max(c) AS max, min(c) AS min FROM INET_TBL; + max | min +-----------------+------------ + 10:23::8000/113 | 10.0.0.0/8 +(1 row) + -- check the conversion to/from text and set_netmask SELECT '' AS ten, set_masklen(inet(text(i)), 24) FROM INET_TBL; ten | set_masklen |