Received: from s20.highertech.net (root@s20.highertech.net [209.54.120.20]) by hub.org (8.9.3/8.9.1) with ESMTP id OAA11361 for ; Wed, 21 Apr 1999 14:31:57 -0400 (EDT) (envelope-from jt-kirkpatrick@mpsllc.com) Received: from kirkpatrickjt (whiteoak-34.highertech.net [209.140.56.34] (may be forged)) by s20.highertech.net (8.8.6/8.8.6) with SMTP id NAA04774 for ; Wed, 21 Apr 1999 13:47:09 -0400 Received: by localhost with Microsoft MAPI; Wed, 21 Apr 1999 14:34:19 -0400 Message-ID: <01BE8C04.0A52A9E0.jt-kirkpatrick@mpsllc.com> From: JT Kirkpatrick To: "'pgsql-sql@hub.org'" Subject: convert text to number or number to text Date: Wed, 21 Apr 1999 14:34:18 -0400 Organization: MPS, LLC X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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