| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | ted(at)php(dot)net |
| Cc: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: enums |
| Date: | 2005-10-28 02:20:51 |
| Message-ID: | 43618B03.8050704@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rod Taylor | 2005-10-28 02:23:27 | Re: enums |
| Previous Message | Christopher Kings-Lynne | 2005-10-28 02:17:22 | Re: TODO Item - Add system view to show free space map |