Re: [SQL] setting select limit? - Mailing list pgsql-sql

From jwieck@debis.com (Jan Wieck)
Subject Re: [SQL] setting select limit?
Date
Msg-id m10AsDU-000EBRC@orion.SAPserv.Hamburg.dsh.de
Whole thread Raw
In response to setting select limit?  ("Frank Morton" <fmorton@base2inc.com>)
List pgsql-sql
>
> If a select is going to match 1000 records, but I only want to
> select the first 25, I thought I could:
>
> select * from table limit 25;
>
> But I guess I can't. How do I limit the query? I've search
> around with no results. Thanks.

    Exactly that syntax is provided for v6.4 in the feature patch
    you find in the patches directory of the ftp server.  And  it
    will be in the standard distribution of v6.5.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #

pgsql-sql by date:

Previous
From: Bob Dusek
Date:
Subject: Re: [GENERAL] Select max field
Next
From: "Neil Burrows"
Date:
Subject: RULE questions.