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 >
