Re: Order by not working

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(dot)coppens(at)datylon(dot)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.