From: | darius(at)dons(dot)net(dot)au |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #9652: inet types don't support min/max |
Date: | 2014-03-21 06:17:35 |
Message-ID: | 20140321061735.28629.38477@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
The following bug has been logged on the website:
Bug reference: 9652
Logged by: Daniel O'Connor
Email address: darius(at)dons(dot)net(dot)au
PostgreSQL version: 9.2.7
Operating system: OSX Mavericks
Description:
reclog=> select * from foo;
bar
---------
1.2.3.4
(1 row)
reclog=> select min(bar) from foo;
ERROR: function min(inet) does not exist
LINE 1: select min(bar) from foo;
^
HINT: No function matches the given name and argument types. You might need
to add explicit type casts.
This is surprising to me since the inet type is ordered, hence min/max are
possible.
You also can't cast an inet to an integer or bigint although I guess that
isn't too surprising since v6 addrs are larger than bigints.
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Hill | 2014-03-21 06:29:26 | Re: BUG #8354: stripped positions can generate nonzero rank in ts_rank_cd |
Previous Message | Marko Tiikkaja | 2014-03-20 08:08:48 | Re: BUG #8870: PL/PgSQL, SELECT .. INTO and the number of result columns |
From | Date | Subject | |
---|---|---|---|
Next Message | MauMau | 2014-03-21 06:54:03 | Re: [bug fix] PostgreSQL fails to start on Windows if it crashes after tablespace creation |
Previous Message | Marcin Mańk | 2014-03-21 05:17:54 | Re: QSoC proposal: Rewrite pg_dump and pg_restore |