convert character varying to int

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
RJ [ Sa, 19 April 2008 04:05 ] [ ID #1948486 ]
Datenbanken » comp.databases.postgresql.sql » convert character varying to int

Vorheriges Thema: General Help on Query Writing, With Defined Schema
Nächstes Thema: Where is potential Afterburner when we need him?