X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D84B53A3C7B for ; Fri, 12 Nov 2004 21:32:15 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 52609-07 for ; Fri, 12 Nov 2004 21:32:03 +0000 (GMT) Received: from dyatel.antar.bryansk.ru (unknown [195.239.214.85]) by svr1.postgresql.org (Postfix) with ESMTP id 84BF93A3BFE for ; Fri, 12 Nov 2004 21:32:03 +0000 (GMT) Received: from fduch by dyatel.antar.bryansk.ru with local (Exim 4.43 (FreeBSD)) id 1CSj1S-000DWF-Hc for pgsql-sql@postgresql.org; Sat, 13 Nov 2004 00:31:58 +0300 Date: Sat, 13 Nov 2004 00:31:58 +0300 From: "Alexander M. Pravking" To: pgsql-sql@postgresql.org Subject: TEXT::CIDR/INET::CIDR output confusion Message-ID: <20041112213158.GF12640@dyatel.antar.bryansk.ru> Mime-Version: 1.0 Content-Type: text/plain; charset=koi8-r Content-Disposition: inline User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/124 X-Sequence-Number: 19443 It looks a bit strange that CIDR output depends on datatype it has been casted from: fduch=# SELECT '1.1.1.1'::cidr; cidr ------------ 1.1.1.1/32 (1 row) fduch=# SELECT '1.1.1.1'::inet::cidr; cidr --------- 1.1.1.1 (1 row) However these two seem to be 'equal' in terms of backend: fduch=# SELECT '1.1.1.1'::inet::cidr = '1.1.1.1'::inet; ?column? ---------- t (1 row) fduch=# SELECT '1.1.1.1'::inet::cidr = '1.1.1.1'::cidr; ?column? ---------- t (1 row) I'm just curious how can it even be... fduch=# SELECT version(); version ------------------------------------------------------------------------------------------------ PostgreSQL 7.4.5 on i386-portbld-freebsd5.3, compiled by GCC cc (GCC) 3.4.2 [FreeBSD] 20040728 -- Fduch M. Pravking