Re: Modular Type Libraries: was A real currency type - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: Modular Type Libraries: was A real currency type
Date
Msg-id 20060322091718.GA29954@svana.org
Whole thread Raw
In response to Re: Modular Type Libraries: was A real currency type  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Tue, Mar 21, 2006 at 10:39:03PM -0500, Tom Lane wrote:
> AFAICS, the main part of the type system that isn't modular is the
> support for type parameters (a/k/a typmod), such as the maximum length
> for varchar or the precision/scale for numeric.  We could certainly
> invent an API for interpreting such parameters.  But in the current state
> of the system the types that have such parameters have to be hard-wired
> into the SQL grammar, and I don't see how to get rid of that hard-wiring
> without breaking a whole lot of stuff.  Any bison gurus hanging about?

We've been here before:

http://archives.postgresql.org/pgsql-hackers/2005-08/msg01142.php

Turns out it isn't too hard, except there are a number of limitations.
Unfortunatly I seem to have the deleted the patch I created then. :(

Summerising the thread then:

- It made some changes to what was and wasn't a reserved word.
- Character sets for CHAR types still fall outside the system.
- Some other changes in behaviour

I'm not sure if much has changed since that discussion.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Automatically setting work_mem
Next
From: Simon Riggs
Date:
Subject: Re: [PATCHES] Automatically setting work_mem