Re: Is it possible to make the order of output the same as the order of input parameters?

From: Yeb Havinga <yebhavinga(at)gmail(dot)com>
To: "m(dot) hvostinski" <makhvost(at)gmail(dot)com>
Cc: Stephen Frost <sfrost(at)snowman(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Is it possible to make the order of output the same as the order of input parameters?
Date: 2010-06-02 15:18:45
Message-ID: 4C067655.7050604@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2010-06-02 15:24:08 Re: Is it possible to make the order of output the same as the order of input parameters?
Previous Message Tom Wilcox 2010-06-02 15:14:57 Re: Out of Memory and Configuration Problems (Big Computer)