Re: Order by not working

[Ron <ronljohnsonjr@xxxxxxxxx>]

    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.coppens@xxxxxxxxxxx> 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.