Re: enums

Ted Rolle wrote:

> This little snippet is great!  The only problem I see is that the 
> enums must be consistent across all modules.
>
> What about loading a variable with a "default" value?  Then it could 
> be adjusted to 'play'.
>
>

You can set a default for a variable using one of these types, as you 
can for any other postgres type:
   create table bar (color rainbow default 'blue');   insert into bar values(default);

As for any postgres type, the default must be a valid value for the type.

cheers

andrew