On Mon, Feb 21, 2005 at 02:52:03PM -0500, Michael A Chase tech wrote:
> On 02/21/2005 02:23 PM, Jeff Zucker said:
>
> >$dbh->do("CREATE FUNCTION foo");
> > # pre-declares function foo, a perl subroutine in current package
> >
> >$dbh->do("CREATE FUNCTION foo AS Bar::baz");
> > # pre-declares function foo, using baz, a subroutine in package Bar
>
> Since AS usually introduces an alias, this might make more sense as:
>
> $dbh -> do( "CREATE FUNCTION Bar::baz AS foo" );
> # predeclares function foo, using baz, a subroutine in package Bar
Actually the best fit with the SQL 1999 standard would be
(in increasing verbosity of optional items):
CREATE FUNCTION foo EXTERNAL
CREATE FUNCTION foo EXTERNAL NAME "Bar::baz"
CREATE FUNCTION foo LANGUAGE Perl EXTERNAL NAME "Bar::baz"
Tim.
