Ticket #198: aa_test.sql

File aa_test.sql, 417 bytes (added by pete@…, 2 years ago)

SQL file defining a PL/Perl function for PostgreSQL - fails in PDO task

Line 
1/*
2Testing function creation through Phing PDO task
3*/
4
5SET client_encoding = 'UTF8';
6SET client_min_messages = warning;
7SET search_path = public, pg_catalog;
8
9CREATE FUNCTION phingPDOtest() RETURNS "trigger"
10    AS $_X$
11if (1)
12{
13    # All is well - just continue
14    return;
15}
16else
17{
18    # Not good - this is probably a fatal error!
19    elog(ERROR,"True is not true");
20    return "SKIP";
21}
22$_X$
23    LANGUAGE plperl;