Re: execution plan : Oracle vs PostgreSQL

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 ?