pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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 ===========
>




view thread (6+ messages)  latest in thread

Message-ID: <000a01c0771a$d8901470$4100fd0a@cabrion.org>
Permalink:  ../000a01c0771a$d8901470$4100fd0a@cabrion.org/
Also on:    postgresql.org/message-id/000a01c0771a$d8901470$4100fd0a@cabrion.org

 · 

reply

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