Re: [SQL] problem with casting

2001-02-16 Thread Gighen Daisuku
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

Re: [SQL] problem with casting

2001-02-15 Thread Josh Berkus
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

[SQL] problem with casting

2001-02-14 Thread postgresql
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?