> Hi !
>
> I'm trying to execute the following query:
> "SELECT TOP 10 * FROM table1"
>
> It gives me the error message
> parser: parse error at or near "2"
>
> Can i use SELECT TOP ?
> Is there any other way to execute the same query not using SELECT TOP
?
>
See the LIMIT clause:
http://www.postgresql.org/idocs/index.php?sql-select.html
Hope this helps,
-- Joe
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
