Re: Order by not working

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
>