From: | Michael Davis <michael(dot)davis(at)prevuenet(dot)com> |
---|---|
To: | "'Kevin Heflin'" <kheflin(at)shreve(dot)net>, "PGSQL-General (E-mail)" <pgsql-general(at)postgreSQL(dot)org> |
Subject: | RE: [GENERAL] limit select question |
Date: | 1999-03-31 07:20:52 |
Message-ID: | 93C04F1F5173D211A27900105AA8FCFC1452FF@lambic.prevuenet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Select * From table_name limit 1;
-----Original Message-----
From: Kevin Heflin [SMTP:kheflin(at)shreve(dot)net]
Sent: Tuesday, March 30, 1999 10:00 PM
To: PGSQL-General (E-mail)
Subject: [GENERAL] limit select question
I've been asked if there is a way to LIMIT the number of results
displayed
when doing a SELECT with postgresql, by a former user of mysql.
Wasn't
sure if there is an easy way to do this or not. I've don't it
before, but
in a very round about way... any suggestions.
> with mySQL and SELECT queries
> you can LIMIT the number of results displayed to the screen. I
can't
> seem to find any such switch in the SELECT commands in postgres.
Kevin
--------------------------------------------------------------------
Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103
VP/Mac Tech | 333 Texas St #619 | FAX:318.221.6612
kheflin(at)shreve(dot)net | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Heflin | 1999-03-31 07:26:21 | RE: [GENERAL] limit select question |
Previous Message | Frédéric Bultot | 1999-03-31 05:37:16 | unsubscribe |