The only problem with 'enum' is that all of the possible values must be
specified at CREATE time.  A logical extension to this would be to allow for
'dynamic extensions' to the list.

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Tuesday, July 03, 2001 4:49 PM
To: Rod Taylor
Cc: dbennett(at)jade(dot)bensoft(dot)com; pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] New SQL Datatype RECURRINGCHAR


"Rod Taylor" <rbt(at)barchord(dot)com> writes:
> This is rather like MySQL's enum.

Yes.  If we were going to do anything like this, I'd vote for stealing
the "enum" API, lock stock and barrel --- might as well be compatible.

			regards, tom lane

In response to

• Re: New SQL Datatype RECURRINGCHAR at 2001-07-03 21:49:18 from Tom Lane

pgsql-hackers by date

Next:	From: Naomi Walker	Date: 2001-07-06 22:51:44
	Subject: 2 gig file size limit
Previous:	From: Bruce Momjian	Date: 2001-07-06 21:59:46
	Subject: Re: [GENERAL] Vacuum and Transactions