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

2003-10-16 Thread Yusuf
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

2003-10-16 Thread Josh Berkus
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