| From: | Ian Lawrence Barwick <barwick(at)gmail(dot)com> |
|---|---|
| To: | pgsql-docs <pgsql-docs(at)postgresql(dot)org> |
| Subject: | Update for sample PL/PgSQL function (section 40.6.4) |
| Date: | 2013-08-23 05:00:26 |
| Message-ID: | CAB8KJ=hG2PMGpO4sPe_MoLzCAOH3jCrGS8oY6KQoPekXV+3HoA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
In the PL/PgSQL documentation, section "40.6.4. Looping Through Query
Results" [1]
contains a sample function which refreshes pseudo-materialized views. As 9.3 has
proper materialized views, I thought it could do with updating. There
was also an erroneous
"%s" in a RAISE NOTICE, and I've tweaked the function definition a bit
to increase its
usefulness as a sample.
Regards
Ian Barwick
| Attachment | Content-Type | Size |
|---|---|---|
| doc-plpgsql-40.6.4.patch | application/octet-stream | 1.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2013-08-23 22:13:26 | Re: BUG #7652: Documentation index lacks functions from "Additional Supplied Modules" |
| Previous Message | Magnus Hagander | 2013-08-20 09:19:35 | Re: A user report of misinterpretation of 'unsupported versions' |