BUG #9652: inet types don't support min/max

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.

Responses

Browse pgsql-bugs by date

  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

Browse pgsql-hackers by date

  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