Re: PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl
David E. Wheeler <david@kineticode.com>
From: "David E. Wheeler" <david@kineticode.com>
To: Richard Huxton <dev@archonet.com>
Cc: Tim Bunce <Tim.Bunce@pobox.com>, Greg Sabino Mullane <greg@endpoint.com>, pgsql-hackers@postgresql.org
Date: 2010-02-16T17:51:34Z
Lists: pgsql-hackers
On Feb 16, 2010, at 9:43 AM, Richard Huxton wrote:
> Perhaps it would be better to be explicit about what's going on?
> SEARCHPATH->function()
> SCHEMA('public')->function2()
>
> Or did "SP" mean "Stored Procedure"?
Yes.
> On a (kind of) related note, it might be worthwhile to mention search_path in the docs and point out it has the same pros/cons as unix file paths.
+1. It's a little like file paths and a little like name spaces, without quite being either one.
Best,
David