Postgres Pro
Downloads
Home   >   mailing lists

Re: specifying table in function args - Mailing list pgsql-general

From David G. Johnston
Subject Re: specifying table in function args
Date
Msg-id CAKFQuwZJ7en+NSd3n4qVjpmrzrPUHoOda-j5o5vLuevYDJL7AQ@mail.gmail.com
Whole thread Raw
In response to specifying table in function args  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: specifying table in function args  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-general
Tree view
On Thursday, February 28, 2019, Rob Sargent <robjsargent@gmail.com> 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.segment fails because pvr() relies on it.


CREATE TYPE?

David J. 

pgsql-general by date:

Previous
From: Ben Chobot
Date:
Subject: Re: automated refresh of dev from prod
Next
From: Michael Lewis
Date:
Subject: Re: Overloaded && operator from intarray module prevents index usage.