Tom Lane wrote:
> "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 to
> the variable when the block is entered. If the DEFAULT clause is not
> given then the variable is initialized to the SQL null value.
Hm, must have missed that paragraph :-(. Sorry for that.
Would a patch that changes that have any chance of being accepted? Or is
the gain (not having to repeat the DEFAULT clause, and being able to
maintain it at one place instead of many) considered too small compared
to the risk of breaking existing code?
best regards,
Florian Pflug