Re: US Telephone Number Type

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Karen Hill" <karen_hill22(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: US Telephone Number Type
Date: 2006-07-11 03:46:49
Message-ID: 8237.1152589609@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Karen Hill" <karen_hill22(at)yahoo(dot)com> writes:
> I did a quick google and someone mentioned that input and output
> functions need to be written in C. Is that still the case?

Yeah, pretty much. The main problem is that such functions need to deal
with whatever physical on-disk format you've chosen for the datatype,
and most of our PLs don't offer bit-level memory access.

If C functions seem like more work than you want to go to for this
problem, I concur with using a domain over text with a regex check
constraint ...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2006-07-11 04:57:02 Re: A function which returns all rolname from pg_roles.
Previous Message Karen Hill 2006-07-11 02:27:38 A function which returns all rolname from pg_roles.