Re: pesky plpgsql

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Walter McGinnis <walter(at)mars-hq(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: pesky plpgsql
Date: 2003-04-03 18:01:36
Message-ID: 200304031001.36024.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Victor Yegorov 2003-04-03 18:38:48 Re: auto-commit
Previous Message Joe Conway 2003-04-03 18:01:01 Re: Foreign key from another database