> 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@xxxxxxxxxxx