Postgres Pro
Downloads
Home   >   mailing lists

Re: Is it possible to make the order of output the same as the order of input parameters? - Mailing list pgsql-general

From Yeb Havinga
Subject Re: Is it possible to make the order of output the same as the order of input parameters?
Date
Msg-id 4C067655.7050604@gmail.com
Whole thread Raw
In response to Re: Is it possible to make the order of output the same as the order of input parameters?  ("m. hvostinski" <makhvost@gmail.com>)
List pgsql-general
Tree view 
m. hvostinski wrote:
> Thanks to all for the feedback. I keep getting impressed by how
> flexible PostgreSQL is.
>
> Any ideas which query should perform better? I put together all the
> suggested approaches below.
EXPLAIN ANALYZE of these queries in psql should give hard numbers. My
bet is on approach 3 to be the fastest since it does not require a join
node and has shorter target list / memory to move around.

regards
Yeb Havinga

pgsql-general by date:

Previous
From: "m. hvostinski"
Date:
Subject: Re: Is it possible to make the order of output the same as the order of input parameters?
Next
From: David Fetter
Date:
Subject: Re: Is it possible to make the order of output the same as the order of input parameters?