Mammoth
  • |
  • Contact
  • |
CMD | Command Prompt, Inc. - PostgreSQL Solutions, Support & Hosting
  • |
  • |
  • |
  • |
  • |
plPerlNG

plPerlNG (Next Generation) provides facilities to write user-defined functions and triggers in Perl for the PostgreSQL database. It is available under the PostgreSQL/BSD license.

Example of ON DELETE Trigger

CREATE OR REPLACE FUNCTION immortal() RETURNS trigger AS '
    if ($_TD->{"old"}{"v"} eq $_TD->{"args"}{0}){
        return "SKIP"; # Skip DELETE command
    } else {
        return;        # Proceed DELETE command
    }
' LANGUAGE 'plperl';


Related Links

Documentation: Complete plPerl docs
Download the source: plPerlNG is now included (Since 8.x) in PostgreSQL core. Please download the PostgreSQL core source for its use.
Join the mailing list: http://lists.pgfoundry.org/mailman/listinfo/plperlng-devel



Copyright © 2000-2013 Command Prompt, Inc. All Rights Reserved. All trademarks property of their respective owners.