| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | josh(at)agliodbs(dot)com |
| Cc: | Bruno Wolff III <bruno(at)wolff(dot)to>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Two Index Questions |
| Date: | 2002-07-19 17:53:45 |
| Message-ID: | 14069.1027101225@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Josh Berkus <josh(at)agliodbs(dot)com> writes:
> I generally try to avoid using LIMIT, as it is a non-SQL92 extension.
Fair enough ...
> Also,
> LIMIT in subqueries might someday be disallowed as it interferes with the
> fundmentally unordered nature of subqueries.
I don't think so; we went out of our way to make it work, so we're
unlikely to discard the feature. It's true that it does prevent some
optimizations that might otherwise occur, but not using it is a
sufficient answer to that.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2002-07-19 17:56:38 | Re: Two Index Questions |
| Previous Message | Tom Lane | 2002-07-19 17:33:29 | Re: [SQL] id and ID in CREATE TABLE |