Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 91B552E002C
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 15 Feb 2008 18:32:30 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 15676-03 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 15 Feb 2008 18:32:26 -0400 (AST)
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by postgresql.org (Postfix) with ESMTP id D3AA62E002D
	for <pgsql-sql@postgresql.org>; Fri, 15 Feb 2008 18:32:26 -0400 (AST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m1FMWPtP000656;
	Fri, 15 Feb 2008 17:32:25 -0500 (EST)
To: "Dean Gibson (DB Administrator)" <postgresql@ultimeth.com>
cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: FUNCTIONs and CASTs 
In-reply-to: <47B5D790.4090509@ultimeth.com> 
References: <47B4C9E4.8090002@ultimeth.com> <20670.1203031191@sss.pgh.pa.us>
	<47B4EF3E.4090608@ultimeth.com> <47B55DA1.1060706@archonet.com>
	<47B5D790.4090509@ultimeth.com>
Comments: In-reply-to "Dean Gibson (DB Administrator)"
	<postgresql@ultimeth.com>
	message dated "Fri, 15 Feb 2008 10:18:56 -0800"
Date: Fri, 15 Feb 2008 17:32:25 -0500
Message-ID: <655.1203114745@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200802/134
X-Sequence-Number: 30225

"Dean Gibson (DB Administrator)" <postgresql@ultimeth.com> writes:
> Again, you are not understanding my point.  My point was that specifying 
> tablename.columnname%TYPE notation doesn't help with the performance 
> problem;  I have to explicitly cast the parameter in the body of the 
> function.

The reason for the lack of communication is that no one else believes
that premise.  Casting a value to the same type it already has is
demonstrably a no-op.

			regards, tom lane