Postgres Pro
Downloads
Home   >   mailing lists

Re: DEFAULT of domain ignored in plpgsql (8.4.1) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: DEFAULT of domain ignored in plpgsql (8.4.1)
Date
Msg-id 19780.1258760855@sss.pgh.pa.us
Whole thread Raw
In response to DEFAULT of domain ignored in plpgsql (8.4.1)  ("Florian G. Pflug" <fgp@phlo.org>)
Responses Re: DEFAULT of domain ignored in plpgsql (8.4.1)
List pgsql-hackers
Tree view 
"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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Partitioning option for COPY
Next
From: Tom Lane
Date:
Subject: Re: [INTERFACES] ecpg & 8.3 -> 8.4 migration