Re: Returning String as Integer

Поиск
Список
Период
Сортировка
От Ben K.
Тема Re: Returning String as Integer
Дата
Msg-id Pine.GSO.4.64.0605061457510.7602@coe.tamu.edu
обсуждение исходный текст
Ответ на Re: Returning String as Integer  (Bruno Wolff III <bruno@wolff.to>)
Ответы Re: Returning String as Integer  (Jorge Godoy <jgodoy@gmail.com>)
Re: Returning String as Integer  (Markus Schaber <schabi@logix-tt.com>)
Список pgsql-sql
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


В списке pgsql-sql по дате отправления:

Предыдущее
От: Bryce Nesbitt
Дата:
Сообщение: Re: grant select on database demo to user
Следующее
От: Jorge Godoy
Дата:
Сообщение: Re: Returning String as Integer