Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

WWWXXXDOCO, nu vot, WWWXXXAPC, dhcpd lease file "binding state", WWWXXXDOCO, how to setup procmail to process html2text, how to setup procmail html2text, WWWXXXAPC., XXXCNZZZ, ss4000 recovery array

Links

XODOX
Impressum

#1: convert character varying to int

Posted on 2008-04-19 04:05:21 by RJ

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

Report this message