Re: Order by in stored functions

Поиск
Список
Период
Сортировка
От Andreas Tille
Тема Re: Order by in stored functions
Дата
Msg-id Pine.LNX.4.21.0009050823500.3065-100000@wr-linux02.rki.de
обсуждение исходный текст
Ответ на Re: Order by in stored functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
On Mon, 4 Sep 2000, Tom Lane wrote:

> This is a bug that has already been fixed in current sources: the check
> that makes sure your select produces only one varchar column is
> mistakenly counting the hidden IdSort column that's needed to sort by.
Is there any patch against 7.0.2 sources which might help me (or the
Debian package maintainer out?
> I don't know of any good workaround in 7.0, short of patching the
> erroneous code.  Have you thought about using a view, rather than a
> function returning set?
I could try that.

Is there any general advise for more or less beginners like me regarding
when to use views and when to use functions?

Kind regards
        Andreas.



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

Предыдущее
От: Craig May
Дата:
Сообщение: Re: pg_hba.conf
Следующее
От: "Umashankar Kotturu"
Дата:
Сообщение: Query on array-elements inside object