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 IAA84993 for ; Mon, 29 Mar 1999 08:44:25 -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 IAA25920 for pgsql-sql@postgresql.org; Mon, 29 Mar 1999 08:15:26 -0500 (EST) Message-Id: <199903291315.IAA25920@websmtp1.bellsouth.bigfoot.com> To: pgsql-sql@postgresql.org Subject: Newbie question about datatype conversion From: "Andrew Douglas" Date: Mon, 29 Mar 1999 08:47:04 -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 BobMart (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 I must be doing something really silly but I just don't see it. Any suggestions? TIA < Note: Redhat Linux 5.2 postgreSQL 6.3.2 > -Andrew adouglas@bellsouth.net