Re: Revamped PL/pgSQL Documentation

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