> select metahsia.sf_pop_hsia_cal_year_tab();
> I got this error :
> ERROR: function to_char(integer) does not exist
> HINT: No function matches the given name and argument types. You may
> need to add explicit type casts
> It seems that its expecting no parameter to default to at least one
> integer parameter. Is this the case? Does this mean that there must
> always be at least one parameter for stored function. None of the
> documentation seems to explicit mention this.
Perhaps, to_char is not being used correctly.
You could try:
psql> \df -- to list all of avaliable functions to see if another one will work
or you could try:
CAST (integer 1234 AS char)
But it is hard to say what the actual problem is with out seeing your function.
Richard Broersma Jr.
In response to
pgsql-novice by date
|Next:||From: Michael Muratet US-Huntsville||Date: 2006-07-21 22:28:21|
|Subject: initdb fails quietly|
|Previous:||From: Patrick Ng||Date: 2006-07-20 15:25:33|
|Subject: Re: RE : How do I compile/test a PL/SQL in Postgresql|