[GENERAL] Stored procedures

From: "Kevin Holbrook" <kevin(at)templegames(dot)com>
To: postgres <pgsql-general(at)postgreSQL(dot)org>
Subject: [GENERAL] Stored procedures
Date: 1999-12-22 17:31:03
Message-ID: 38610AD7.2ED8CB36@templegames.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I am using version 6.5.3, and have a quick question on CREATE
FUNCTION.

Now, it seems that "LIMIT clause from SQL functions not yet
implemented".

Any ideas on how I could somehow limit the number of results coming
back?
I want to grab the top 100 records out of a table with of 60K
records or so.

Any help would be greatly appreciated.

Thanks!

-Kevin Holbrook

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 1999-12-22 17:39:34 Re: [GENERAL] Index pg_proc_prosrc_index: NUMBER OF INDEX' TUPLES (1071)ISNOT THE SAME AS HEAP' (1070)
Previous Message Mike Mascari 1999-12-22 17:08:48 Re: [GENERAL] Getting value of SERIAL column after insert from libpq?