convert character varying to int
am 19.04.2008 04:05:21 von RJHi,
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