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/