RE: New SQL Datatype RECURRINGCHAR

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