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.copp...@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.
