Re: CREATE TYPE example needed - Mailing list pgsql-general

From Tom Lane
Subject Re: CREATE TYPE example needed
Date
Msg-id 1487.1042671033@sss.pgh.pa.us
Whole thread Raw
In response to Re: CREATE TYPE example needed  ("Jim Buttafuoco" <jim@spectrumtelecorp.com>)
List pgsql-general
"Jim Buttafuoco" <jim@spectrumtelecorp.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

pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: Re: postgres on a PDA
Next
From: Justin Clift
Date:
Subject: PostgreSQL and Data warehousing question