Thanks, Dan
> On Feb 16, 2021, at 12:11 PM, Ron <ronljohnso...@gmail.com> wrote: > > 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> >>> <mailto: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.
