Re: Order by not working - Mailing list pgsql-general

From Dan Nessett
Subject Re: Order by not working
Date
Msg-id 1D84F613-D7C7-4EC0-95EF-4FBB56D0F160@yahoo.com
Whole thread Raw
In response to Re: Order by not working  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Thanks,

Dan

On Feb 16, 2021, at 12:11 PM, Ron <ronljohnsonjr@gmail.com> wrote:

What would you tell pgadmin?  "Order this particular query -- out of all the billion queries I might write -- in this particular manner?"

No, that's not how things work.  Just add an ORDER BY when you query the table.

On 2/16/21 12:48 PM, Dan Nessett wrote:
Thanks Peter. The listing of the result is from pg-admin 4.30 using view/edit data applied to the household_data table. In the past this has always returned the table contents in the ORDR BY sort order. Do I need to specify some preference in pg_admin to guarantee this?

Dan

On Feb 16, 2021, at 11:34 AM, Peter Coppens <peter.coppens@datylon.com> wrote:

Not sure how you select the household

The result is (only the first column is shown):

household_name

"Garcia"
"Armstrong"
"Armstrong"
"Bauer"
"Bauer"
"Berst"
"Berst"
"Minch (xxxx)"
"Berst"
“Besel”
but unless you select from the resulting table using again an order by, the rows will be returned in an undetermined order. Such is the nature of the relational model - there is no order you can rely on when selecting, unless you specify it

Hth,

Peter



--
Angular momentum makes the world go 'round.

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Order by not working
Next
From: "David G. Johnston"
Date:
Subject: Re: Order by not working