> On
>>> regards, tom lane
>> Did my message with a sql and plgpsql versions not come through?
>> I cannot create a plain sql function unless the search_path covers any table mentioned. Not the case when using
plpgsql- no path needed.
>
> But does the plpgsql segment_calls() run?
>
> On other words does:
>
> select * from segment_calls(segid uuid);
>
> work?
>
>> I'm ok(ish) with that, unless I've missed some detail.
>> rjs
>
Yes the plpgsql form works but of course requires a sufficient search_path
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
