Re: specifying table in function args

On Thu, Feb 28, 2019 at 1:56 PM Rob Sargent wrote: > HINT: No function matches the given name and argument types. You might need > to add explicit type casts. Pretty sure you need to heed the advice to make it work. select pvr(s::public.segment) from mm.segment AS s limit 5; David J.

Re: specifying table in function args

On 2/28/19 12:27 PM, David G. Johnston wrote: On Thursday, February 28, 2019, Rob Sargent > wrote: but this fails in one of two ways:  either the create function call fails lacking a definition of "segment" or, if I create a public.segment table, create

Re: specifying table in function args

On Thursday, February 28, 2019, Rob Sargent wrote: > but this fails in one of two ways: either the create function call fails > lacking a definition of "segment" or, if I create a public.segment table, > create the function, set search_path to include a project's schema then > drop public.segmen

specifying table in function args

Using PG10.7, I have a database per investigator with one or more identical schemata per project.  So far I've gotten by defining public functions (as postgres) which reference tables /without/ schema reference.  Each project has a role which sets the search_path such that the project specific