SQL Server Common Library Runtime and PostgreSQL PL/Perl

Questa pagina non è tradotta nella tua lingua. Richiedi traduzione

SQL Server Usage

SQL Server provides the capability of implementing .NET objects in the database using the Common Runtime Library (CLR). The CLR enables development of functionality that would be complicated using T-SQL.

The CLR provides robust solutions for string manipulation, date manipulation, and calling external services such as Windows Communication Foundation (WCF) services and web services.

You can create the following objects with the EXTERNAL NAME clause:

PostgreSQL Usage

Amazon Aurora PostgreSQL-Compatible Edition (Aurora PostgreSQL) doesn’t support .NET code. However, you can create Perl functions. In this case, convert all C# code to PL/pgSQL or PL/Perl.

To use PL/Perl language, install the Perl extension:

CREATE EXTENSION plperl;

After you install the Perl extension, you can create functions using Perl code. Specify plperl in the LANGUAGE clause.

You can create the following objects with Perl:

Examples

The following example creates a function that returns the greater value of two integers.

CREATE FUNCTION perl_max (integer, integer) RETURNS integer AS $$
  if ($_[0] > $_[1]) { return $_[0]; }
  return $_[1];
$$ LANGUAGE plperl;

For more information, see PL/Perl — Perl Procedural Language in the PostgreSQL documentation.