Re: Oracle and Postgresql
| От | SCassidy@overlandstorage.com |
|---|---|
| Тема | Re: Oracle and Postgresql |
| Дата | |
| Msg-id | OF30D723D5.F0FF3785-ON882574B9.00552D9F-882574B9.0055CEFF@overlandstorage.com обсуждение исходный текст |
| Ответ на | Re: Oracle and Postgresql (Artacus <artacus@comcast.net>) |
| Ответы |
Re: Oracle and Postgresql
|
| Список | pgsql-general |
I don't know if Oracle changed recently, but the last few times I used it, it was incredibly annoying having to put everything in a subquery to get a LIMIT-type operation to work AFTER the sort, so that you could use their ROWNUM. For example, to get the first 50 rows of a SELECT result. Their ROWNUM worked BEFORE the ORDER BY, so to get the 1st 50 rows, you had to put the query in a subselect, and say SELECT ... where ROWNUM <= 50.
I love OFFSET ... LIMIT in PostgreSQL! I do a lot of web applications, and it is incredibly handy to page output with.
Susan
----------------------------------------------------
Tiered Data Protection Made Simple
http://www.overlandstorage.com/
----------------------------------------------------
В списке pgsql-general по дате отправления: