Re: [SQL] setting select limit?

Поиск
Список
Период
Сортировка
От jwieck@debis.com (Jan Wieck)
Тема Re: [SQL] setting select limit?
Дата
Msg-id m10AsDU-000EBRC@orion.SAPserv.Hamburg.dsh.de
обсуждение исходный текст
Ответ на setting select limit?  ("Frank Morton" <fmorton@base2inc.com>)
Список 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 по дате отправления:

Предыдущее
От: Bob Dusek
Дата:
Сообщение: Re: [GENERAL] Select max field
Следующее
От: "Neil Burrows"
Дата:
Сообщение: RULE questions.