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 t
voyé : mercredi 1 février 2006 17:05
À : FERREIRA, William (VALTECH)
Cc : pgsql-performance@postgresql.org
Objet : Re: [PERFORM] execution plan : Oracle vs PostgreSQL
"FERREIRA, William (VALTECH)" <[EMAIL PROTECTED]> writes:
> My test document has 115000 nodes.
> the export o
"FERREIRA, William (VALTECH)" <[EMAIL PROTECTED]> writes:
> My test document has 115000 nodes.
> the export of the document(extracting all informations from database and
> writing XML file on disk) takes 30s with Oracle and 5mn with Postgresql.
> The Oracle stored procedure is written in pl/sql an
hi,
i have a database storing XML documents.
The main table contains the nodes of the document, the other tables contain
data for each node (depending on the node's type : ELE, Text, PI, ...)
My test document has 115000 nodes.
the export of the document(extracting all informations from database
