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