| 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: | Raw Message | Whole Thread | 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!!
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.
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...
| 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 |