Re: Function returning subset of columns from table (return type)

From: brian <brian(at)zijn-digital(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Function returning subset of columns from table (return type)
Date: 2008-02-04 01:32:51
Message-ID: 47A66B43.3010904@zijn-digital.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2008-02-04 01:43:28 Re: Performance problems with Postgresql/ZFS/Non-global zones on Solaris?
Previous Message Greg Smith 2008-02-04 01:32:27 Re: PostgreSQL Certification