Received: from erm1.u-strasbg.fr (erm1.u-strasbg.fr [130.79.74.61]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eAKES9s19857 for ; Mon, 20 Nov 2000 09:28:10 -0500 (EST) (envelope-from bboett@erm1.u-strasbg.fr) Received: (qmail 22693 invoked by uid 501); 20 Nov 2000 14:45:01 -0000 Date: Mon, 20 Nov 2000 15:45:01 +0100 From: Bruno Boettcher To: pgsql-sql@postgresql.org Subject: More stupid questions: prettyprinting of ints?? Message-ID: <20001120154501.A25191@erm1.u-strasbg.fr> Reply-To: bboett@erm1.u-strasbg.fr Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0.1i X-Archive-Number: 200011/151 X-Sequence-Number: 182 hello, the thing i am making is a bookkepping program. This program handles multiple currencies, each currency is formatted a bit differently on from the other. I do store the amounts as int's in the DB... In another table i have sample format strings that could be used to format them... but if there is an inbuild functionality to format currencies, i will gladly take it.... on the other hand is it possible to make substring operations in postgres (some examples somewhere)? What would be the best way to implement this thing? -- ciao bboett ============================================================== bboett@earthling.net http://inforezo.u-strasbg.fr/~bboett http://erm1.u-strasbg.fr/~bboett =============================================================== the total amount of intelligence on earth is constant. human population is growing....