Re: Function returning subset of columns from table (return type) - Mailing list pgsql-general

From brian
Subject Re: Function returning subset of columns from table (return type)
Date
Msg-id 47A66B43.3010904@zijn-digital.com
Whole thread Raw
In response to Re: Function returning subset of columns from table (return type)  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
List pgsql-general
Gurjeet Singh wrote:
>
> All's okay, except you should not have declared it IMMUTABLE, because the
> results depend on a database query.
>
> From the docs:
> IMMUTABLE indicates that the function cannot modify the database and always
> returns the same result when given the same argument values; that is, it does
> not do database lookups or otherwise use information not directly present in
> its argument list
>

Yes, my bad. Make that STABLE.

b

pgsql-general by date:

Previous
From: "Christopher Browne"
Date:
Subject: Re: postgresql book - practical or something newer?
Next
From: Greg Smith
Date:
Subject: Re: Performance problems with Postgresql/ZFS/Non-global zones on Solaris?