Date: Tue, 13 May 2003 14:24:28 -0500
From: Larry Rosenman <ler@lerctr.org>
To: pgsql-sql@postgresql.org
Subject: Ok, how do I debug THIS? 
Message-ID: <246160000.1052853868@lerlaptop.iadfw.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I'm getting:
ERROR:  parse error at or near "IF"
WARNING:  plpgsql: ERROR during compile of networks_trigger_log near line 
206
$

but the function is:

$ wc -l z
     147 z
$ head z
CREATE OR REPLACE FUNCTION networks_trigger_log () RETURNS "trigger"
    AS 'DECLARE
    record_fields_old text;
    record_values_old text;
    record_fields_new text;
    record_values_new text;
    query_string_old text;
    query_string_new text;
    BEGIN
    query_string_old := ''INSERT INTO networks_log'';
$

How do I find my stupidity?
$ psql
Welcome to psql 7.3.2, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

ler=# select version();
                               version
---------------------------------------------------------------------
 PostgreSQL 7.3.2 on i386-portbld-freebsd4.7, compiled by GCC 2.95.4
(1 row)

ler=#


-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749