Skip site navigation (1) Skip section navigation (2)

Re: Fixed length datatypes. WAS [GENERAL] UUID's as

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: mark(at)mark(dot)mielke(dot)cc
Cc: Martijn van Oosterhout <kleptog(at)svana(dot)org>,Thomas Hallgren <thomas(at)tada(dot)se>, Josh Berkus <josh(at)agliodbs(dot)com>,Andrew Dunstan <andrew(at)dunslane(dot)net>,"A(dot)M(dot)" <agentm(at)themactionfaction(dot)com>,PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fixed length datatypes. WAS [GENERAL] UUID's as
Date: 2006-06-30 17:45:13
Message-ID: 20060630174512.GE17241@pervasive.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
On Fri, Jun 30, 2006 at 12:39:52PM -0400, mark(at)mark(dot)mielke(dot)cc wrote:
> > Only this could be used to create other types too, for cryptographic
> > functions for example. PostgreSQL doesn't have any type generators yet,
> > so I'm unsure whether a patch creating one would be accepted for core.
> 
> Not sure what I think of this. I suppose the intention would be for it
> to work for lengths other than 16? I can see people wanting to use such
> a generalized function for char as well as bytea, for at least latin1
> characters...
> 
> If people agree to a generic 16-byte type, or a hex type with defined
> fixed length with a set of standard functions and index operators that
> it should work for, but nobody more qualified wants to make the patch
> - I'll step up.

I think it'd be extremely useful to have a means of defining
fixed-length hex types, such as UUIDs and hashes (ie: SHA1). I usually
only see people trying to do the same thing for CHAR in poorly-designed
systems, but I suspect anyone dealing with legacy stuff might welcome
that ability as well.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby(at)pervasive(dot)com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-06-30 17:59:26
Subject: Re: Fixed length datatypes. WAS [GENERAL] UUID's as
Previous:From: Tom LaneDate: 2006-06-30 17:29:38
Subject: Re: optimizing constant quals within outer joins

pgsql-general by date

Next:From: Tom LaneDate: 2006-06-30 17:59:26
Subject: Re: Fixed length datatypes. WAS [GENERAL] UUID's as
Previous:From: Tom LaneDate: 2006-06-30 17:41:53
Subject: Re: Notes on converting from MySQL 5.0.x to PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group