X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id ADC28D1C914
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Aug 2003 09:23:50 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 09253-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Aug 2003 06:22:31 -0300 (ADT)
Received: from gateway.dauphin-mm.nl (wc-234.r-195-85-176.essentkabel.com
	[195.85.176.234])
	by svr1.postgresql.org (Postfix) with ESMTP id 8F770D1C910
	for <pgsql-sql@postgresql.org>; Wed,  6 Aug 2003 06:23:35 -0300 (ADT)
Received: from pc-005.brommer.nl (pc-065.intranet.dauphin-mm.nl
 [192.168.0.65])
	by gateway.dauphin-mm.nl (Postfix) with ESMTP id 64A13BC9E
	for <pgsql-sql@postgresql.org>; Wed,  6 Aug 2003 11:23:43 +0200 (CEST)
Message-Id: <5.1.0.14.2.20030806111628.00ba12f0@192.168.0.1>
X-Sender: brommer@mx.friendly.net
X-Mailer: QUALCOMM Windows Eudora Version 5.1
Date: Wed, 06 Aug 2003 11:23:40 +0200
To: pgsql-sql@postgresql.org
From: Martin Brommer <martin@brommer.nl>
Subject: Using rowtype as function argument
In-Reply-To: <Pine.LNX.4.56.0307301050540.1171@krusty.credativ.de>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/47
X-Sequence-Number: 14663

Hi all,

I suppose this must be easy to figure out, but I can't find it anywhere in 
the documentation.

How do I call a function that takes a rowtype for an argument as in:

CREATE FUNCTION myfunc(mytablename) RETURNS INT AS '
BEGIN
	-- Do stuff
	RETURN val;
END;
' LANGUAGE 'plpgsql'

How do I call this function? I haven't been able to figure it out or find 
it anywhere...

Thanks in advance,


Martin