Skip site navigation (1) Skip section navigation (2)

pgsql: SQL:2008 alternative syntax for LIMIT/OFFSET: OFFSET num

From: petere(at)postgresql(dot)org (Peter Eisentraut)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: SQL:2008 alternative syntax for LIMIT/OFFSET: OFFSET num
Date: 2008-10-22 11:00:34
Message-ID: 20081022110034.9CA0B7545A4@cvs.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
SQL:2008 alternative syntax for LIMIT/OFFSET:
OFFSET num {ROW|ROWS} FETCH {FIRST|NEXT} [num] {ROW|ROWS} ONLY

Modified Files:
--------------
    pgsql/doc/src/sgml/ref:
        select.sgml (r1.106 -> r1.107)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/select.sgml?r1=1.106&r2=1.107)
        select_into.sgml (r1.41 -> r1.42)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/select_into.sgml?r1=1.41&r2=1.42)
        values.sgml (r1.4 -> r1.5)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/values.sgml?r1=1.4&r2=1.5)
    pgsql/src/backend/catalog:
        sql_features.txt (r1.23 -> r1.24)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/sql_features.txt?r1=1.23&r2=1.24)
    pgsql/src/backend/parser:
        gram.y (r2.627 -> r2.628)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/gram.y?r1=2.627&r2=2.628)
        keywords.c (r1.203 -> r1.204)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/keywords.c?r1=1.203&r2=1.204)

pgsql-committers by date

Next:From: Teodor SigaevDate: 2008-10-22 12:53:56
Subject: pgsql: Fix GiST's killing tuple: GISTScanOpaque->curpos wasn't
Previous:From: Tom LaneDate: 2008-10-21 20:42:54
Subject: pgsql: Add a concept of "placeholder" variables to the planner.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group