Re: pesky plpgsql - Mailing list pgsql-sql

From Josh Berkus
Subject Re: pesky plpgsql
Date
Msg-id 200304031001.36024.josh@agliodbs.com
Whole thread Raw
In response to pesky plpgsql  (Walter McGinnis <walter@mars-hq.com>)
Responses Re: pesky plpgsql  (Roberto Mello <rmello@cc.usu.edu>)
Re: pesky plpgsql  ("Walter McGinnis" <web@mars-hq.com>)
List pgsql-sql
Walter,

> CREATE FUNCTION update_cat_keys() RETURNS integer AS '
> declare
>    v_row         RECORD;

What's in-between v_row and RECORD?   Maybe a non-standard tab character?

That's the only thing I can see, as the rest of your syntax looks fine.

(FYI, in PL/pgSQL, your function is not compiled until you run it.)

--
-Josh BerkusAglio Database SolutionsSan Francisco



pgsql-sql by date:

Previous
From: "Victor Yegorov"
Date:
Subject: Re: auto-commit
Next
From: Joe Conway
Date:
Subject: Re: Foreign key from another database