"Lee Harr" <missive(at)hotmail(dot)com> writes:
> I should note that this_program() is defined as VOLATILE.
So don't do that ;-)
> It was a while ago, but I believe this is because I have
> a this_program() defined in each schema and they
> return a different value depending on which schema
> you are in when you call the function...
But each one of these is individually immutable, no? If it's not,
how are you expecting your query-builder function to give the same
answers as before?
regards, tom lane