Re: Casting

Yes. Casts are done like this:

SomeFiled::int4

or SomeField::text

Double colons is the key '::'
--rob

----- Original Message -----
From: "Thomas SMETS" <tsmets(at)altern(dot)org>
To: "psql novice" <pgsql-novice(at)postgresql(dot)org>; "psql sql"
<pgsql-sql(at)postgresql(dot)org>
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(at)altern(dot)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 ===========
>