X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 41AFBD1B503
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 16 Oct 2003 23:26:35 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 04126-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 16 Oct 2003 20:26:07 -0300 (ADT)
Received: from smtp-send.myrealbox.com (smtp-send.myrealbox.com
	[192.108.102.143])
	by svr1.postgresql.org (Postfix) with ESMTP id 323D7D1B53C
	for <pgsql-sql@postgresql.org>; Thu, 16 Oct 2003 20:26:04 -0300 (ADT)
Received: from yusufad [148.240.24.190] by myrealbox.com
	with NetMail ModWeb Module; Thu, 16 Oct 2003 17:26:06 -0600
Subject: Re: Can't convert numeric to_char() in catenate function 
From: "Yusuf" <yusufad@myrealbox.com>
To: pgsql-sql@postgresql.org
Date: Thu, 16 Oct 2003 17:26:06 -0600
X-Mailer: NetMail ModWeb Module
X-Sender: yusufad
MIME-Version: 1.0
Message-ID: <1066346766.8551e800yusufad@myrealbox.com>
Content-Type: text/plain; charset="ISO-8859-5"
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200310/198
X-Sequence-Number: 15598

I 'must' quote the quotes. I 'must' quote the quotes. I 'must' quote the qu=
otes. I 'must' quote the quotes. I 'must' quote the quotes. I 'must' quote =
the quotes. I 'must' quote the quotes.=20

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 ''m=
ust'' quote the quotes. I ''must'' quote the quotes. I ''must'' quote the q=
uotes.=20

Err, sorry about that, I'm trying to keep something in my mind.  I just wan=
ted to tell ya to forget my previous mail, I got it (tipical) just after se=
nding 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 =3D ''''=20
		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 ''m=
ust'' quote the quotes. I ''must'' quote the quotes. I ''must'' quote the q=
uotes. 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'' quot=
e 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...