convert text to number or number to text - Mailing list pgsql-sql

From JT Kirkpatrick
Subject convert text to number or number to text
Date
Msg-id 01BE8C04.0A52A9E0.jt-kirkpatrick@mpsllc.com
Whole thread Raw
List pgsql-sql
I'm trying to do an update query that compares an int4 field to a variable 
which I think contains a string (it was passed in through cgi.pm).  can I 
convert that string to an integer? - it will always be a number passing 
through.  I vaguely remember oracle having a to_number function - does 
postgres have something similar?

jt



pgsql-sql by date:

Previous
From: "Brett W. McCoy"
Date:
Subject: Re: [SQL] perl and postgres. . .
Next
From: Àíäðåé Íîâèêîâ
Date:
Subject: default in ALTER