Re: [SQL] SELECT TOP X -- part 2 -- parse error? - Mailing list pgsql-sql

Justin Long ha scritto:

> Thanks for the answers. I downloaded and installed PG5... now I have a new
> problem. I can't seem to access any documentation on the syntax of the new
> additions to PG5, and I'm getting a parse error with the following command
>
>         SELECT * FROM database LIMIT 5
                                        ^^^^^^^^
database ????
the right syntax is:   SELECT * FROM table LIMIT 5

>
> It says
>
>         parse error at or near "5"
>

EXAMPLE:

prova=> select * from test limit 1; v|  c|  i
---+---+---
123|123|123
(1 row)

José