Re: FUNCTIONs and CASTs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dean Gibson (DB Administrator)" <postgresql(at)ultimeth(dot)com>
Cc: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: FUNCTIONs and CASTs
Date: 2008-02-15 22:32:25
Message-ID: 655.1203114745@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Dean Gibson (DB Administrator)" <postgresql(at)ultimeth(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dean Gibson (DB Administrator) 2008-02-15 23:03:02 Re: FUNCTIONs and CASTs
Previous Message Emi Lu 2008-02-15 18:28:14 Re: String function to Find how many times str2 is in str1?