Re: Can I create a TYPE (or DOMAIN) with arguments?

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Erik Jones <erik(at)myemma(dot)com>
Cc: "R(dot)A(dot)" <adeveloper(at)bluebottle(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Can I create a TYPE (or DOMAIN) with arguments?
Date: 2008-01-10 15:57:43
Message-ID: 20080110155743.GE29714@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jan 10, 2008 at 08:58:07AM -0600, Erik Jones wrote:
> Postgres doesn't support parameterized type declarations directly
> (that I've ever heard of), but you could probably write a function
> that uses EXECUTE to do this.

IIRC 8.3 will include the user-defined typmod which will allow such
constructs...

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-01-10 16:01:46 Re: Setting variables equal to elements from an Array
Previous Message Isak Hansen 2008-01-10 15:54:15 Re: 8.2.4 serious slowdown