Re: UNION and LIMIT issue

From: ljb <lbayuk(at)pobox(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: UNION and LIMIT issue
Date: 2007-07-20 01:41:05
Message-ID: f7p3rg$ukj$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

tgl(at)sss(dot)pgh(dot)pa(dot)us wrote:
>...
> ISTM that a LIMIT without an ORDER BY is a pretty bad idea, btw.

Some databases actually output a warning when you do that, telling you your
result is non-deterministic. Which seems to me to be a little presumptuous...

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Bryce Nesbitt 2007-07-22 03:10:55 The nested view from hell - Restricting a subquerry
Previous Message Tom Lane 2007-07-19 22:27:59 Re: UNION and LIMIT issue