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