Výběr záznamů od .. do

[Karel Zak]

On Mon, Nov 26, 2001 at 12:06:58PM +0100, Artur Kudelka wrote:
> PostgreSQL podporuje LIMIT od ktere verse ? Mam ted 6.5.3...
> Diky.


test=> SELECT version();
version
-------------------------------------------------------------
PostgreSQL 6.5.3 on i686-pc-linux-gnu, compiled by gcc 2.95.2
(1 row)
 
test=> \h SELECT
Command: select
Description: retrieve tuples
Syntax:
        SELECT [DISTINCT [ON attrN]] expr1 [AS attr1], ...exprN
        [INTO [TEMP] [TABLE] class_name]
        [FROM from_list]
        [WHERE qual]
        [GROUP BY group_list]
        [HAVING having_clause]
        [ { UNION [ALL] | INTERSECT | EXCEPT } SELECT ...]
        [ORDER BY attr1 [ASC|DESC] [USING op1], ...attrN ]
        [FOR UPDATE [OF class_name...]]
        [LIMIT count [OFFSET|, count]];                                                                                 
         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

     Karel

-- 
 Karel Zak  <zakkr na zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/
 
 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz