Re: [HACKERS] indexes and floats - Mailing list pgsql-hackers

From Thomas G. Lockhart
Subject Re: [HACKERS] indexes and floats
Date
Msg-id 35C94654.67FB6617@alumni.caltech.edu
Whole thread Raw
In response to RE: [HACKERS] indexes and floats  ("Jackson, DeJuan" <djackson@cpsgroup.com>)
List pgsql-hackers
> This would be logical to me because we allow function creation.
> Consider, if someone creates an SQL function on a table being updated
> that returns a count of all rows who's index matches an int.  Which
> would mean that an insert using that function to select rows could
> need to be evaluated for each row.
> Well, I guess what I'm trying to say is that the current behavior
> could be desired/being used by someone.

As you point out, the current behavior allows functions with
side-effects to work, where if we change it then functions must be
side-effect-free. Most functions do not have side effects, though one
using the SPI interface for example might be prone to them.

We _could_ add a column attribute for each function which declares a
function as being "safe" or not.

                      - Tom

pgsql-hackers by date:

Previous
From: Peter T Mount
Date:
Subject: Re: [HACKERS] SPI procedure for removing large objects
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Large objects names