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: | CA+OCxoycSc5zvOLXHAnG=OWn3Y0NdrzSjv_8GgRCBGTEp121dQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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");
else
orderBy += wxT(" DESC");
}
Essentially, we try to follow the ordering in the index.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Erwin Brandstetter | 2011-07-26 18:13:13 | Re: Changed default ordering in tables |
Previous Message | Erwin Brandstetter | 2011-07-26 15:47:01 | Changed default ordering in tables |