Received: from websmtp1.bellsouth.bigfoot.com (websmtp1.bellsouth.bigfoot.com [208.156.60.91]) by hub.org (8.9.2/8.9.1) with ESMTP id QAA81285 for ; Fri, 26 Mar 1999 16:11:50 -0500 (EST) (envelope-from douglasa@bellsouth.net) Received: from bigfoot (www4.bellsouth.bigfoot.com [208.156.60.164]) by websmtp1.bellsouth.bigfoot.com (8.9.1/8.9.1) with SMTP id PAA01984 for pgsql-sql@postgresql.org; Fri, 26 Mar 1999 15:42:17 -0500 (EST) Message-Id: <199903262042.PAA01984@websmtp1.bellsouth.bigfoot.com> To: pgsql-sql@postgresql.org Subject: newbie question about type conversions From: "Andrew Douglas" Date: Fri, 26 Mar 1999 16:13:15 -0500 X-Originating-IP: 205.131.174.1 I can't seem to figure out how to convert a varchar to a text or a text to char or anything. I've tried doing exactly as the good documentation says but this is the kind of response I get... foo=> select orgname from organization; orgname ---------------------- Douglas Ventures Progressive Consulting (2 rows) foo=> \d organization; <---SNIP---> | orgname | varchar() not null | 25 | <---SNIP---> foo=> select text(orgname) from organization; ERROR: function text(varchar) does not exist foo=> select orgname::text from organization; ERROR: function text(varchar) does not exist foo=> select char(orgname) from organization; ERROR: parser: parse error at or near "orgname" foo=> select orgname::char from organization; ERROR: function char(varchar) does not exist any suggestions?