| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Florian G(dot) Pflug" <fgp(at)phlo(dot)org> |
| Cc: | Postgresql-Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: DEFAULT of domain ignored in plpgsql (8.4.1) |
| Date: | 2009-11-20 23:47:35 |
| Message-ID: | 19780.1258760855@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"Florian G. Pflug" <fgp(at)phlo(dot)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.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2009-11-20 23:56:59 | BUG #5206: wal_sync_method in stock postgresql.conf may be wrong |
| Previous Message | Tom Lane | 2009-11-20 23:40:53 | Re: Partitioning option for COPY |