Quick Pg/PLSQL question

Hey everyone,

Trying to run a VERY simple function.  I've read through the Programmer's
Manual over and over, and continue to receive errors.  First, I ran the
following to add the language to the database:

    createlang plpgsql test

I then load the function using:

    \i test_func.sql

I then run the function by simply executing:

    select test_func() as answer;


The function I'm trying to execute is:

------------------------------------------

CREATE OR REPLACE FUNCTION test_func() RETURNS INTEGER AS '

DECLARE

BEGIN

    INSERT INTO transaction_summary VALUES (61, 1, "now", 0, 0, 0, 0);

    RETURN 1;

END;
' LANGUAGE 'plpgsql';

------------------------------------------

Very simple function, but I continue to receive errors, because of the "now"
part.  However, in the Programmer's Manual, it specifically uses "now" with
double quotes in a couple examples.  When executing the function, I continue
receiving the following errors:

NOTICE:  Error occurred while executing PL/pgSQL function test_func
NOTICE:  line 4 at SQL statement
ERROR:  Attribute 'now' not found


Any help would be greatly appreciated.

Thank you,
Matt Wagner

Envex Developments
Your CGI Script Specialists
http://www.envex.net/