Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] Stored procedures - Mailing list pgsql-general

From Kevin Holbrook
Subject [GENERAL] Stored procedures
Date
Msg-id 38610AD7.2ED8CB36@templegames.com
Whole thread Raw
List pgsql-general
Tree view 
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

pgsql-general by date:

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