Re: Support for SQL TOP clause? - Mailing list pgsql-sql

From Reinoud van Leeuwen
Subject Re: Support for SQL TOP clause?
Date
Msg-id 20080110114623.GF41164@spoetnik.xs4all.nl
Whole thread Raw
In response to Re: Support for SQL TOP clause?  ("Phillip Smith" <phillip.smith@weatherbeeta.com.au>)
List pgsql-sql
On Thu, Jan 10, 2008 at 02:19:43PM +1100, Phillip Smith wrote:
> SELECT *
> 
> FROM   Individual
> 
> LIMIT 3

Note that you will have to add an 'order by' clause to guarantee 
predictable results...

-- 
__________________________________________________
"Nothing is as subjective as reality"
Reinoud van Leeuwen    reinoud.v@n.leeuwen.net
http://www.xs4all.nl/~reinoud
__________________________________________________


pgsql-sql by date:

Previous
From: Paul Lambert
Date:
Subject: Re: Shorthand column labels (SELECT col1 foo, ...) vs (SELECT col1 AS foo, ...)
Next
From: Richard Broersma Jr
Date:
Subject: Re: Support for SQL TOP clause?