Re: [Firebird-devel] ROWS

[Arno B. <fir...@ab...>]

Hi,

> I have a suggestion to introduce a ROWS clause in the SELECT statements.
The
> semantics is the same as in FIRST/SKIP, but with one major difference - it
> allows to handle unions correctly. This issue was unfortunately missed
when
> we agreed on FIRST/SKIP, although the original John's idea (LIMIT x, y)
was
> designed correctly. Unions can have only one ORDER BY clause and only one
> limitation clause. Since the syntax of FIRST/SKIP is designed to be a part
> of subqueries, it makes this clause impossible to use with unions in a
> proper way.

Will this break existing applications which use?:

SELECT
  FIRST 1 r.*
FROM
  RDB$RELATIONS r
UNION ALL
SELECT
  FIRST 1 SKIP 1 r.*
FROM
  RDB$RELATIONS r

If not i can do?:

SELECT
  FIRST 1 r.*
FROM
  RDB$RELATIONS r
UNION ALL
SELECT
  FIRST 1 SKIP 1 r.*
FROM
  RDB$RELATIONS r
ORDER BY
  RDB$RELATION_NAME
  ROWS 1


Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird links :
  http://www.firebirdsql.com
  http://www.firebirdsql.info
  http://www.fingerbird.de/
  http://www.comunidade-firebird.org/


Nederlandse firebird nieuwsgroep :
news://80.126.130.81