Re: FUNCTIONs and CASTs - Mailing list pgsql-sql

From Tom Lane
Subject Re: FUNCTIONs and CASTs
Date
Msg-id 655.1203114745@sss.pgh.pa.us
Whole thread Raw
In response to Re: FUNCTIONs and CASTs  ("Dean Gibson (DB Administrator)" <postgresql@ultimeth.com>)
Responses Re: FUNCTIONs and CASTs
List pgsql-sql
"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


pgsql-sql by date:

Previous
From: Emi Lu
Date:
Subject: Re: String function to Find how many times str2 is in str1?
Next
From: "Dean Gibson (DB Administrator)"
Date:
Subject: Re: FUNCTIONs and CASTs