Re: Order by in stored functions

From: Andreas Tille <tillea(at)rki(dot)de>
To:
Cc: PostgreSQL SQL <pgsql-sql(at)hub(dot)org>
Subject: Re: Order by in stored functions
Date: 2000-09-05 06:26:06
Message-ID: Pine.LNX.4.21.0009050823500.3065-100000@wr-linux02.rki.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Oliver Seidel 2000-09-05 07:40:28 array column -- do you really want this?
Previous Message Umashankar Kotturu 2000-09-05 03:12:29 Query on array-elements inside object