Re: CREATE TYPE example needed

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jim(at)contactbda(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: CREATE TYPE example needed
Date: 2003-01-15 22:50:33
Message-ID: 1487.1042671033@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Jim Buttafuoco" <jim(at)spectrumtelecorp(dot)com> writes:
> Thanks for the answer Tom, I did want to write varchar2(n). Is this
> something special in the code? Could I somehow muck with the system
> catalogs and copy varchar.

Nope, won't help you. varchar(n) is hard-wired in the grammar. Since
there are so few datatypes that have specialized syntax, there's no
provision for extensibility of that syntax.

Short of a lot of cutting-and-pasting in the parser, I don't think
you're going to get it to work.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-01-15 22:55:57 Re: Problem handling timezones
Previous Message Jim Buttafuoco 2003-01-15 22:38:54 Re: CREATE TYPE example needed