Unordered SELECT - random vs undefined
Keith Gabryelski submitted this comment for the docs, which I rejected
as a comment, but think still needs correcting in the docs:
the line:
When a table is read, the rows will appear in random order, unless
sorting is explicitly requested
should be:
When a table is read, the rows will appear in an undefined order,
unless sorting is explicitly requested.
This applies to: http://www.postgresql.org/docs/current/static/ddl-basics.html
--
Thom Brown
Registered Linux user: #516935
Thom Brown <thom@linux.com> writes:
should be:
When a table is read, the rows will appear in an undefined order,
unless sorting is explicitly requested.
Perhaps "unspecified" is le mot juste.
regards, tom lane
On 20 August 2010 14:45, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Thom Brown <thom@linux.com> writes:
should be:
When a table is read, the rows will appear in an undefined order,
unless sorting is explicitly requested.Perhaps "unspecified" is le mot juste.
Yes, that sounds more appopriate.
--
Thom Brown
Registered Linux user: #516935
Thom Brown <thom@linux.com> writes:
On 20 August 2010 14:45, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Perhaps "unspecified" is le mot juste.
Yes, that sounds more appopriate.
OK, done. I found one other place in the docs where "random" seemed
to be used inappropriately, too.
regards, tom lane