Re: varchar, text and cidr

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Welty <rwelty(at)averillpark(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: varchar, text and cidr
Date: 2003-08-05 00:07:18
Message-ID: 17789.1060042038@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard Welty <rwelty(at)averillpark(dot)net> writes:
> On Mon, 04 Aug 2003 18:07:49 -0400 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joseph Shraibman 2003-08-05 00:48:44 Re: like performance w/o wildcards.
Previous Message Tom Lane 2003-08-05 00:05:37 Re: like performance w/o wildcards.