Re: varchar, text and cidr

Richard Welty <rwelty@averillpark.net> writes:
> On Mon, 04 Aug 2003 18:07:49 -0400 Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> 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( varchar);
> ERROR:  CreateCast: function cidr(character varying) does not exist

Yeah, you'd need to create a pg_proc entry for cidr(varchar) --- though
you can get away with letting it point to the implementation function
for cidr(text).

            regards, tom lane