Hi,

I'm using postgres sql 8.1x

anyone can help convert a character varying to int?

I have a table with :
attribute | character varying(20)

and I need to convert it to numbers so I can do some calculation.

tried
select cast(privilege.value as int)

didn't work.

please help.

Thanks

begin RJ wrote:
simple example:

test=*# select regexp_replace('abc123def','[^0-9]','','g')::int * 10;
?column?
----------
1230




end
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

begin RJ wrote:
simple example:

test=*# select regexp_replace('abc123def','[^0-9]','','g')::int * 10;
?column?
----------
1230




end
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

begin RJ wrote:
simple example:

test=*# select regexp_replace('abc123def','[^0-9]','','g')::int * 10;
?column?
----------
1230




end
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

begin RJ wrote:
simple example:

test=*# select regexp_replace('abc123def','[^0-9]','','g')::int * 10;
?column?
----------
1230




end
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

begin RJ wrote:
simple example:

test=*# select regexp_replace('abc123def','[^0-9]','','g')::int * 10;
?column?
----------
1230




end
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

begin RJ wrote:
simple example:

test=*# select regexp_replace('abc123def','[^0-9]','','g')::int * 10;
?column?
----------
1230




end
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

begin RJ wrote:
simple example:

test=*# select regexp_replace('abc123def','[^0-9]','','g')::int * 10;
?column?
----------
1230




end
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

begin RJ wrote:
simple example:

test=*# select regexp_replace('abc123def','[^0-9]','','g')::int * 10;
?column?
----------
1230




end
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

In article <2cipd5-ttt.ln1 (AT) news (DOT) a-kretschmer.de>, Andreas Kretschmer <akretschmer (AT) spamfence (DOT) net> wrote:
It's not too clear what you want. If attribute only contains numbers it's
easier than Andreas' example:

select (CAST(attribute as int) *2) from ...

Eric