Re: varchar, text and cidr

On Mon, 04 Aug 2003 18:07:49 -0400 Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Richard Welty <rwelty@averillpark.net> writes:
> > On Mon, 04 Aug 2003 16:58:29 -0400 Tom Lane <tgl@sss.pgh.pa.us> wrote:
> >> Lack of an entry in pg_cast for varchar->cidr.  Feel free to create
> one.

> > if i knew how to determine the oid for a data type, i certainly would.

> You don't have to.  See CREATE CAST.

cool. although it does look like there's still a piece missing:

test=# create cast( varchar as cidr) with function cidr( text);
ERROR:  argument of cast function must match source data type
test=# create cast( varchar as cidr) with function cidr( varchar);
ERROR:  CreateCast: function cidr(character varying) does not exist

which i find interesting, since i can use the cidr funtion directly on
the varchar field:

test=#  select * from vctest where '192.0.2.5'::cidr << cidr( baz);
     baz
--------------
 192.0.2.0/24
(1 row)

note that i'm not in any big rush to deal with this, the cast-of-a-cast is
working ok at my customer's site.

oh well,
  richard
--
Richard Welty                                         rwelty@averillpark.net
Averill Park Networking                                         518-573-7592
    Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security