Re: Returning String as Integer

From: "Ben K(dot)" <bkim(at)coe(dot)tamu(dot)edu>
To: pgsql-sql(at)postgresql(dot)org
Cc: Jorge Godoy <jgodoy(at)gmail(dot)com>
Subject: Re: Returning String as Integer
Date: 2006-05-06 20:05:36
Message-ID: Pine.GSO.4.64.0605061457510.7602@coe.tamu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Jorge Godoy <jgodoy(at)gmail(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jorge Godoy 2006-05-06 21:38:14 Re: Returning String as Integer
Previous Message Bryce Nesbitt 2006-05-06 19:46:13 Re: grant select on database demo to user