"Nathan Suderman" <[EMAIL PROTECTED]> writes: > how can I convert varchar to int? I can not seem to cast the type > (::int2) and there are no conversion functions in the docs > (int(varchar)). What Postgres version are you using? This works fine for me in 7.0 and later... regards, tom lane