Skip site navigation (1) Skip section navigation (2)

pgsql: Add note that LIMIT without ORDER BY can produce outright

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add note that LIMIT without ORDER BY can produce outright
Date: 2007-06-08 20:26:18
Message-ID: 20070608202618.2B12E9FBDBE@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Add note that LIMIT without ORDER BY can produce outright nondeterministic
results.  Necessary due to introduction of syncscan patch.

Modified Files:
--------------
    pgsql/doc/src/sgml/ref:
        select.sgml (r1.100 -> r1.101)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/select.sgml.diff?r1=1.100&r2=1.101)

pgsql-committers by date

Next:From: Alvaro HerreraDate: 2007-06-08 21:09:49
Subject: pgsql: Avoid passing zero as a value for vacuum_cost_limit, because it's
Previous:From: Bruce MomjianDate: 2007-06-08 18:45:22
Subject: pgsql: Done: < * Allow sequential scans to take advantage of other

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group