"Florian G. Pflug" <fgp@phlo.org> writes:
> It seems that pl/pgsql ignores the DEFAULT value of domains for local
> variables.
The plpgsql documentation seems entirely clear on this:
The DEFAULT clause, if given, specifies the initial value assigned tothe variable when the block is entered. If the
DEFAULTclause is notgiven then the variable is initialized to the SQL null value.
regards, tom lane