Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

bash netcat eof, 192.168.1.41:8000, Www.xxxcon., %s wwwxxxcon, %s wwwxxxcon, www.xxxcon, xxxxdup, bitlord outgoing port settings, ckowwwxxx, 192.168.1.41:8000/nor-482.html

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