Re: pl/pgsql Composite Parameter Question

From: Holger Krug <hkrug(at)rationalizer(dot)com>
To: cnliou(at)eurosport(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pl/pgsql Composite Parameter Question
Date: 2002-01-21 06:58:57
Message-ID: 20020121075857.A754@dev12.rationalizer.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jan 21, 2002 at 04:19:36AM +0000, cnliou(at)eurosport(dot)com wrote:
> BEGIN
> InRec ALIAS FOR $1;
> RAISE NOTICE ''%'',InRec.c1;
> RETURN TRUE;
> END;' LANGUAGE 'plpgsql';

Correct would be:

DECLARE
InRec ALIAS FOR $1;
BEGIN
RAISE NOTICE ''%'',InRec.c1;
RETURN TRUE;
END;' LANGUAGE 'plpgsql';

--
Holger Krug
hkrug(at)rationalizer(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nikola Milutinovic 2002-01-21 07:02:57 How to return "more thatn one value" from Pl/PgSQL?
Previous Message Thomas Lockhart 2002-01-21 06:56:29 Re: [HACKERS] PostgreSQL Licence: GNU/GPL