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

Reply via email to