Re: Query - Mailing list pgsql-general

From Joe Conway
Subject Re: Query
Date
Msg-id 00aa01c13ca6$6133d8b0$6cdc10ac@jecw2k1
Whole thread Raw
In response to Query  ("Tamara D. Blum" <tblum@jus.gov.ar>)
List pgsql-general
> 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


pgsql-general by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Re: Query
Next
From: Gunnar Rønning
Date:
Subject: Re: business perspective