--- On Wed, 1/9/08, Chinyi Woo <[EMAIL PROTECTED]> wrote:
> Does Postgresql support query like SELECT *TOP 3* * FROM
> Individual ? If I use ORDER BY, I have to write non-sql
> code to get the first row in the result set, which I try
> to avoid.
As you have seen, PostgreSQL's implementation of L
On Thu, Jan 10, 2008 at 02:19:43PM +1100, Phillip Smith wrote:
> SELECT *
>
> FROM Individual
>
> LIMIT 3
Note that you will have to add an 'order by' clause to guarantee
predictable results...
--
__
"Nothing is as subjective as reality"
Reino
SELECT *
FROM Individual
LIMIT 3
I asked the reverse question moving from PG to MSSQL :-(
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Chinyi Woo
Sent: Thursday, 10 January 2008 14:14
To: pgsql-sql@postgresql.org
Subject: [SQL] Support for
Hello, everyone
Does Postgresql support query like SELECT *TOP 3* * FROM Individual ? If I
use ORDER BY, I have to write non-sql code to get the first row in the
result set, which I try to avoid.
Thanks
Chinyi