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 22:07:48
Message-ID: CAKFQuwa-MA0B-Rq+YkqecWLoTncsWVNDWj+5nKd2kKmsY5w5YA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Feb 28, 2019 at 1:56 PM Rob Sargent <robjsargent(at)gmail(dot)com> 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2019-02-28 22:34:20 Re: Overloaded && operator from intarray module prevents index usage.
Previous Message Győző Papp 2019-02-28 21:45:31 race condition when checking uniqueness between two tables