Quick Links

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

From:	"Yusuf" <yusufad(at)myrealbox(dot)com>
To:	pgsql-sql(at)postgresql(dot)org
Subject:	Re: Can't convert numeric to_char() in catenate function
Date:	2003-10-16 23:26:06
Message-ID:	1066346766.8551e800yusufad@myrealbox.com
Views:	Whole Thread \| Raw Message \| Download mbox \| Resend email
Thread:
Lists:	pgsql-sql

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

Err, sorry about that, I'm trying to keep something in my mind. I just wanted to tell ya to forget my previous mail, I got it (tipical) just after sending it:

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 ltrim('' '', to_char($2,''999999999D99''))
ELSE $1 || '', '' || ltrim('' '', to_char($2,''99999999D99''))
END
' LANGUAGE 'sql';

Ciao.

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. 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. 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. I ''must'' quote the quotes. I ''must'' quote the quotes. I ''must'' quote the quotes...

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Jordan S. Jones	2003-10-16 23:26:28	Re: Postgres with OpenSSL
Previous Message	Josh Berkus	2003-10-16 23:04:00	Re: Can't convert numeric to_char() in catenate function