Received: from aeon.tvd.be (aeon.tvd.be [195.162.196.20]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f050YT737666; Thu, 4 Jan 2001 19:34:29 -0500 (EST) (envelope-from tsmets@altern.org) Received: from altern.org (cable-213-132-133-148.upc.chello.be [213.132.133.148]) by aeon.tvd.be (8.9.3/8.9.3/RELAY-1.1) with ESMTP id BAA24425; Fri, 5 Jan 2001 01:34:53 +0100 (MET) Message-ID: <3A5515DE.52F2DB7B@altern.org> Date: Fri, 05 Jan 2001 01:31:26 +0100 From: Thomas SMETS Organization: Private X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.2.9-27mdk i686) X-Accept-Language: en MIME-Version: 1.0 To: psql novice , psql sql Subject: Casting Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200101/38 X-Sequence-Number: 502 Hi, In pgsql I'm removing charaters from a String which should be numbers. I then want to make calculations on these numbers (calculate the ISBN number). Do I have to cast the char into int's before I can do the calulations. Also I looked in the User manual but could not find the modulo function where is it ? tx, Thomas, -- Thu Jan 4 20:19:03 CET 2001 Thomas SMETS e-mail : tsmets@altern.org Av. de la Brabançonne 133 / 3 Tel. : +32 (0)2 742. 05. 94. 1030 Bruxelles ======= Quote of the Day ========= Jealousy is all the fun you think they have. ========= End of Quote ===========