Re: extensible enum types - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: extensible enum types
Date
Msg-id 1277005850.5130.9.camel@jd-desktop.iso-8859-1.charter.com
Whole thread Raw
In response to Re: extensible enum types  (Peter Geoghegan <peter.geoghegan86@gmail.com>)
List pgsql-hackers
On Sun, 2010-06-20 at 03:42 +0100, Peter Geoghegan wrote:
> >> Thoughts?

> It's very cool to be able to write queries like SELECT * FROM payments
> WHERE payment_type = 'cash', rather than having to recall time and
> again what the PK of cash is within your lookup table.

Ahem. That is what a natural key is for :) 

Joshua D. Drake


> 
> -- 
> Regards,
> Peter Geoghegan
> 

-- 
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering



pgsql-hackers by date:

Previous
From: Florian Pflug
Date:
Subject: Re: beta3 & the open items list
Next
From: Simon Riggs
Date:
Subject: Small FSM is too large