[GENERAL] Stored procedures

Поиск
Список
Период
Сортировка
От Kevin Holbrook
Тема [GENERAL] Stored procedures
Дата
Msg-id 38610AD7.2ED8CB36@templegames.com
обсуждение исходный текст
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: Mike Mascari
Дата:
Сообщение: Re: [GENERAL] Getting value of SERIAL column after insert from libpq?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [GENERAL] Index pg_proc_prosrc_index: NUMBER OF INDEX' TUPLES (1071)ISNOT THE SAME AS HEAP' (1070)