Skip site navigation (1) Skip section navigation (2)

Re: Changed default ordering in tables

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Erwin Brandstetter <brandstetter(at)falter(dot)at>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Changed default ordering in tables
Date: 2011-07-26 16:12:28
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-hackers
Hi Erwin

On Tue, Jul 26, 2011 at 4:47 PM, Erwin Brandstetter
<brandstetter(at)falter(dot)at> wrote:
> Aloha!
> In  v1.14 tables are opened with ORDER BY $pkey DESC.
> I wonder if descending order ist intended. It used to be the other way round
> and, as far as I am concerned, that was just fine in most cases.
> We have the new feature "View Data" .. "View top / last 100 rows" anyway. No
> need to change the default behavior?

The default is determined like this:

       orderBy = table->GetQuotedPrimaryKey();
       if (orderBy.IsEmpty() && hasOids)
            orderBy = wxT("oid");
       if (!orderBy.IsEmpty())
           if (pkAscending)
                orderBy += wxT(" ASC");
              orderBy += wxT(" DESC");

Essentially, we try to follow the ordering in the index.

Dave Page
Twitter: @pgsnake

EnterpriseDB UK:
The Enterprise PostgreSQL Company

In response to


pgadmin-hackers by date

Next:From: Erwin BrandstetterDate: 2011-07-26 18:13:13
Subject: Re: Changed default ordering in tables
Previous:From: Erwin BrandstetterDate: 2011-07-26 15:47:01
Subject: Changed default ordering in tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group