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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster