Re: ENUM like data type

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: MRB <nomail(at)example(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: ENUM like data type
Date: 2005-06-28 12:37:20
Message-ID: 20050628123720.GA20566@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

On Tue, Jun 21, 2005 at 17:20:19 +0200,
MRB <nomail(at)example(dot)com> wrote:
>
> Here is where I get uncertain as to if this is possible. My idea is to
> create a pseudo type that triggers the creation of it's lookup tables
> the same way the SERIAL type triggers creation of a sequence and returns
> an int with the right default value.

You might want to look at using a domain to do this.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2005-06-28 12:51:21 Re: Implementing SQL/PSM for PG 8.2 - debugger
Previous Message Andrew Dunstan 2005-06-28 12:30:44 Re: Problem with dblink regression test

Browse pgsql-sql by date

  From Date Subject
Next Message Bruno Wolff III 2005-06-28 12:47:33 Re: cross-table reference
Previous Message Sergey Levchenko 2005-06-28 11:39:39 ERROR: "TZ"/"tz" not supported