> -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general- > owner@xxxxxxxxxxxxxx] On Behalf Of Tom Lane > Sent: Wednesday, November 08, 2006 7:05 AM > To: redhog > Cc: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: [GENERAL] Stable sort? > > "redhog" <redhog@xxxxxxxxxx> writes: > > My question was if the order of two > > elements whose internal order is not affected by the current ordering > > clause, still may change places due to technicalities. > > Postgres usually sorts using qsort(), which (on most platforms) is not > stable in that sense. This is (of course) what we would expect from any SQL database.
