Postgres Pro
Downloads
Home   >   mailing lists

Re: UNION and LIMIT issue - Mailing list pgsql-sql

From ljb
Subject Re: UNION and LIMIT issue
Date
Msg-id f7p3rg$ukj$1@news.hub.org
Whole thread Raw
In response to UNION and LIMIT issue  (Howard Smith <hsmith@visualmining.com>)
List pgsql-sql
Tree view 
tgl@sss.pgh.pa.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...

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: UNION and LIMIT issue
Next
From: Bryce Nesbitt
Date:
Subject: The nested view from hell - Restricting a subquerry