In data Wed, 14 Feb 2001 21:10:30 + (UTC), postgresql scrive:
>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 c
Ted,
> 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?
'fraid so. You cannot cast Date as Text, because (presumably) the DB
engine doesn't know how you want to form
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?