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.
In response to
- Re: enums at 2005-10-27 20:54:36 from Ted Rolle
pgsql-hackers by date
|Next:||From: Rod Taylor||Date: 2005-10-28 02:23:27|
|Subject: Re: enums|
|Previous:||From: Christopher Kings-Lynne||Date: 2005-10-28 02:17:22|
|Subject: Re: TODO Item - Add system view to show free space map|