Received: from racerx.cabrion.com (racerx.cabrion.com [166.82.231.4]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f05DK3799055; Fri, 5 Jan 2001 08:20:03 -0500 (EST) (envelope-from rob@cabrion.com) Received: from cabrionhome (gso163-25-153.triad.rr.com [24.163.25.153]) by racerx.cabrion.com (8.8.7/8.8.7) with SMTP id IAA07786; Fri, 5 Jan 2001 08:20:25 -0500 Message-ID: <000a01c0771a$d8901470$4100fd0a@cabrion.org> From: "rob" To: "Thomas SMETS" , "psql novice" , "psql sql" References: <3A5515DE.52F2DB7B@altern.org> Subject: Re: Casting Date: Fri, 5 Jan 2001 08:24:34 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200101/47 X-Sequence-Number: 511 Yes. Casts are done like this: SomeFiled::int4 or SomeField::text Double colons is the key '::' --rob ----- Original Message ----- From: "Thomas SMETS" To: "psql novice" ; "psql sql" Sent: Thursday, January 04, 2001 7:31 PM Subject: Casting > > > 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 =========== >