Re: [SQL] Can't convert numeric to_char() in catenate function

I 'must' quote the quotes. I 'must' quote the quotes. I 'must' quote the quotes. I 'must' quote the quotes. I 'must' quote the quotes. I 'must' quote the quotes. I 'must' quote the quotes. DANG!! I ''must'' quote the quotes. I ''must'' quote the quotes. I ''must'' quote the quotes. I ''must''

[SQL] Can't convert numeric to_char() in catenate function

Hi there. Im trying to do the usual row catenation function, but for a "numeric" type column. I have this: CREATE OR REPLACE FUNCTION "verticat" (text, numeric) RETURNS text AS ' SELECT CASE WHEN $2 IS NULL THEN $1 WHEN $1 IS NULL OR $1 = THEN to_char($2,'