Re: How can I retrieve an info about function arguments ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Zuev Dmitry" <envoy1(at)chat(dot)ru>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How can I retrieve an info about function arguments ?
Date: 2002-10-25 14:25:41
Message-ID: 22855.1035555941@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Zuev Dmitry" <envoy1(at)chat(dot)ru> writes:
> Consider a function:
> create function f(varchar(10), decimal(10,1)) returns integer as 'select 1;'

There is no distinction between such a function and a function declared
create function f(varchar, decimal)
Function arguments do not have length restrictions attached to them.

If they did, we couldn't write functions like numeric_add() and
textcat(), but would need an infinite number of variations of these
for each possible input length.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-10-25 14:32:02 Re: Help with error message
Previous Message Andrew Sullivan 2002-10-25 14:18:27 Re: postgresql 7.2.1 and smp ?