Re: CONVERT function is seriously broken

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Tom Lane wrote:
>> Unfortunately, I don't see any way offhand to fix this without an
>> initdb :-(.

> Ooch, that hurts. How bad would it be if it was broken in 7.3?

We could dike out the feature:

convert_list:
a_expr USING any_name
{
elog(ERROR, "CONVERT(... USING ...) is not implemented");
}

Short of that, I think we need an initdb to change the function
signature for the convert() function. It needs to take a (suitably
quoted) text parameter, not an OID.

Since we forced initdb only a week ago with beta3, I don't think there
is really a strong argument against doing it again. But probably Marc
will say that we need a beta4 at this point, instead of going for RC1...

regards, tom lane