Re: specifying table in function args

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Rob Sargent <robjsargent(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: specifying table in function args
Date: 2019-02-28 19:27:56
Message-ID: CAKFQuwZJ7en+NSd3n4qVjpmrzrPUHoOda-j5o5vLuevYDJL7AQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thursday, February 28, 2019, Rob Sargent <robjsargent(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Lewis 2019-02-28 20:23:12 Re: Overloaded && operator from intarray module prevents index usage.
Previous Message Ben Chobot 2019-02-28 19:26:10 Re: automated refresh of dev from prod