| From: | Andrew Lazarus <andrew(at)pillette(dot)com> |
|---|---|
| To: | "FERREIRA, William (VALTECH)" <william(dot)ferreira(at)airbus(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: execution plan : Oracle vs PostgreSQL |
| Date: | 2006-02-06 20:36:15 |
| Message-ID: | 43E7B33F.4030509@pillette.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Indeed there is: you can use an ARRAY constructor with SELECT. Here's
some PGPLSQL code I have (simplified and with the variable names shrouded).
SELECT INTO m
ARRAY(SELECT d FROM hp
WHERE hp.ss=$1
ORDER BY 1);
FERREIRA, William (VALTECH) wrote:
> maybe there is an other way to query children directly into an array and having query plan caching ?
| Attachment | Content-Type | Size |
|---|---|---|
| andrew.vcf | text/x-vcard | 298 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Browne | 2006-02-06 22:15:16 | Re: Default autovacuum settings too conservative |
| Previous Message | Vivek Khera | 2006-02-06 20:00:12 | Re: Default autovacuum settings too conservative |