Re: [SQL] SELECT TOP X -- part 2 -- parse error?

From: José Soares <jose(at)sferacarta(dot)com>
To: justinlong(at)xc(dot)org
Cc: pgsql-sql(at)hub(dot)org
Subject: Re: [SQL] SELECT TOP X -- part 2 -- parse error?
Date: 1999-04-23 14:25:47
Message-ID: 372082EB.B7589C22@sferacarta.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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é

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Justin Long 1999-04-23 14:33:54 FW: [SQL] SELECT TOP _x_ ??
Previous Message Julian Scarfe 1999-04-23 10:30:14 Re: [SQL] Finding the "most recent" rows