From: rob <rob@cabrion.com>
To: Thomas SMETS <tsmets@altern.org>
To: psql novice <pgsql-novice@postgresql.org>
To: psql sql <pgsql-sql@postgresql.org>
Subject: Re: Casting
Date: Fri, 5 Jan 2001 08:24:34 -0500
Message-ID: <000a01c0771a$d8901470$4100fd0a@cabrion.org> (raw)
References: <3A5515DE.52F2DB7B@altern.org>
Yes. Casts are done like this:
SomeFiled::int4
or SomeField::text
Double colons is the key '::'
--rob
----- Original Message -----
From: "Thomas SMETS" <tsmets@altern.org>
To: "psql novice" <pgsql-novice@postgresql.org>; "psql sql"
<pgsql-sql@postgresql.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@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 ===========
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rob@cabrion.com, tsmets@altern.org, pgsql-novice@postgresql.org
Subject: Re: Casting
In-Reply-To: <000a01c0771a$d8901470$4100fd0a@cabrion.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox