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''

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

Yusuf, > 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,'9D99') > ELSE $1 || '', '' || to_char($2,'D99') You need to escape your s

[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,'