Re: pl/pgsql Composite Parameter Question - Mailing list pgsql-general

From Holger Krug
Subject Re: pl/pgsql Composite Parameter Question
Date
Msg-id 20020121075857.A754@dev12.rationalizer.com
Whole thread Raw
In response to pl/pgsql Composite Parameter Question  (<cnliou@eurosport.com>)
List pgsql-general
On Mon, Jan 21, 2002 at 04:19:36AM +0000, cnliou@eurosport.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@rationalizer.com

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] PostgreSQL Licence: GNU/GPL
Next
From: Thomas Lockhart
Date:
Subject: Re: [HACKERS] PostgreSQL Licence: GNU/GPL