Re: [GENERAL] Current Schema for Functions called within other Functions

2013-04-01 Thread Lee Hachadoorian
Merlin, Perfect. Thank you. Best, --Lee On Mon, Apr 1, 2013 at 10:04 AM, Merlin Moncure wrote: > On Sun, Mar 31, 2013 at 5:32 PM, Lee Hachadoorian > wrote: > > I'm working on some PL/pgSQL functions to generate dynamic SQL. The > > functions live in the public schema, but the SQL generated w

Re: [GENERAL] Current Schema for Functions called within other Functions

2013-04-01 Thread Merlin Moncure
On Sun, Mar 31, 2013 at 5:32 PM, Lee Hachadoorian wrote: > I'm working on some PL/pgSQL functions to generate dynamic SQL. The > functions live in the public schema, but the SQL generated will vary > depending on what schema they are called from. Something is going on which I > cannot figure out.

[GENERAL] Current Schema for Functions called within other Functions

2013-03-31 Thread Lee Hachadoorian
I'm working on some PL/pgSQL functions to generate dynamic SQL. The functions live in the public schema, but the SQL generated will vary depending on what schema they are called from. Something is going on which I cannot figure out. I am defining "variables" by creating a getter function within eac