On Wed, Aug 16, 2006 at 07:21:06PM -0400, Gregory Stark wrote:
> This is the same issue we have with char(n) and numeric(x,y) already. If we
> found a general solution for getting the type name to the enum would it also
> help getting the typmod to char(n) and numeric(x,y)? Would it let us store
> those as fixed sized data types?
Hopefully. It would be great to also have a fixed-width raw/bytea field.
See the recent discussions about adding a guid type, etc.
How about this for a TODO:
* Allow for field widths to be stored in the catalog instead of each tuple
Data types such as char are usually used when the user knows that a field will always contain a fixed amount of
data.In these cases, our char implementation is wasteful, because the varlena header always contains the same
value.If there was a mechanism to obtain field widths from the catalog there would be no need to store the field
widthin each tuple. This would be useful for other types as well (UUID and ENUM, for example).
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461