Re: Order by in stored functions - Mailing list pgsql-sql

From Andreas Tille
Subject Re: Order by in stored functions
Date
Msg-id Pine.LNX.4.21.0009050823500.3065-100000@wr-linux02.rki.de
Whole thread Raw
In response to Re: Order by in stored functions  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Craig May
Date:
Subject: Re: pg_hba.conf
Next
From: "Umashankar Kotturu"
Date:
Subject: Query on array-elements inside object