Re: Program Syntax Help Needed - Mailing list pgsql-novice

From Michael Glaesemann
Subject Re: Program Syntax Help Needed
Date
Msg-id 9F0356D9-6DAD-4353-9544-FE9E5B6E095D@seespotcode.net
Whole thread Raw
In response to Program Syntax Help Needed  (SIMON@hslc.org)
List pgsql-novice
On Apr 27, 2010, at 15:07 , SIMON@hslc.org wrote:

> Hello -
>
> I am new to PostgreSQL and trying to create a program to update a table, but I
> am getting syntax errors.
>
> Here is my program:
>
> -------------------------------------------------------------
> -- Import copy_note data
> CREATE OR REPLACE FUNCTION add_copy_notes() RETURNS integer AS '
> DECLARE
>    copynote RECORD;

<snip />

> ' LANGUAGE SQL;

You're using PL/pgSQL syntax in a function declared to be in language SQL. Try using LANGUAGE PLPGSQL instead.

Michael Glaesemann
grzm seespotcode net


pgsql-novice by date:

Previous
From: SIMON@hslc.org
Date:
Subject: Program Syntax Help Needed
Next
From: Urs Rau
Date:
Subject: how to continue after error in batch mode with psql