Received: from symcom.com ([209.11.41.82]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1EL5fx84448 for ; Wed, 14 Feb 2001 16:05:41 -0500 (EST) (envelope-from pgsql@symcom.com) Message-Id: <200102142105.f1EL5fx84448@mail.postgresql.org> Received: from WorldClient [209.11.41.82] by symcom.com [209.11.41.82] with SMTP (MDaemon.v3.5.0.R) for ; Wed, 14 Feb 2001 16:10:49 -0500 Date: Wed, 14 Feb 2001 16:10:49 -0500 From: "postgresql" To: pgsql-sql@postgresql.org Subject: problem with casting MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Mailer: WorldClient Pro 2.2.1 X-MDRemoteIP: 209.11.41.82 X-Return-Path: pgsql@symcom.com X-MDaemon-Deliver-To: pgsql-sql@postgresql.org X-Archive-Number: 200102/271 X-Sequence-Number: 1462 I have a table that has a 'date' column. In psql I tried to do a select proofdate::text from openjobs where jobno = '10625'; responce:   can not cast type 'date' to 'text' Did i miss-read this section. I thought I could cast the date to text. has anyone seen this or am I missreading the docs? thanks Ted