Thanks Peter. The listing of the result is from pg-admin 4.30 using view/edit data applied to the household_data table.
Inthe past this has always returned the table contents in the ORDR BY sort order. Do I need to specify some preference
inpg_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
>