Roberto Mello <rmello@cc.usu.edu> writes:
> The part that confuses me is the end. I assume that if you specify
> DEFAULT you must specify a value. Am I right in understanding that
> notation as meaning:
> name [ CONSTANT ] type [ NOT NULL ] [ DEFAULT value | := value ];
> or perhaps it could be written like this:
> name [ CONSTANT ] type [ NOT NULL ] [ { DEFAULT | := } value ];
Use the source, Luke ... a quick look into plpgsql's gram.y shows that
the latter is correct, ie, 'DEFAULT' and ':=' are interchangeable
introducers for an initialization expression.
regards, tom lane