Re:AWS Babelfish: The Elephant in the PostgreSQL Room?
by dragonwriter on Friday February 12, 2021 @09:56PM
(#26120993)
> Oracle DB doesn't support "TOP N" or "LIMIT N" notations and many other useful features...
Instead of those nonstandard notations Oracle supports SQL-standard notation OFFSET and FETCH clauses (Postgres supports both LIMIT/OFFSET and OFFSET/FETCH, but not TOP.) OFFSET/FETCH is, IIRC, slightly more powerful than the nonstandard ones.
Instead of those nonstandard notations Oracle supports SQL-standard notation OFFSET and FETCH clauses (Postgres supports both LIMIT/OFFSET and OFFSET/FETCH, but not TOP.) OFFSET/FETCH is, IIRC, slightly more powerful than the nonstandard ones.