Re: Revamped PL/pgSQL Documentation

Roberto Mello <rmello(at)cc(dot)usu(dot)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