From: Ben K. <bkim@coe.tamu.edu>
To: pgsql-sql@postgresql.org
Cc: Jorge Godoy <jgodoy@gmail.com>
Subject: Re: Returning String as Integer
Date: Sat, 6 May 2006 15:05:36 -0500 (CDT)
Message-ID: <Pine.GSO.4.64.0605061457510.7602@coe.tamu.edu> (raw)
In-Reply-To: <20060506153916.GA3434@wolff.to>
References: <18AE59788A3FC640A367E5652E664D8002093F0C@xmb-sjc-237.amer.cisco.com>
<200605051852.19596.jgodoy@gmail.com>
<20060506153916.GA3434@wolff.to>
Jorge Godoy <jgodoy@gmail.com> wrote:
> numbers. Is there any way to select a value from this column and return
> it as an integer?
My twopence. I just happened to have the same problem with iReports for a
10 digit number - it may be case specific but in my case
# select ... int4(id) ...;
worked.
I tried int8(id) but java didn't take it as Integer. (It took int8 as
something like Long.)
Regards,
Ben
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: bkim@coe.tamu.edu, jgodoy@gmail.com
Subject: Re: Returning String as Integer
In-Reply-To: <Pine.GSO.4.64.0605061457510.7602@coe.tamu.edu>
* 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