Re: error: cast the timestam expression - Mailing list pgsql-sql

On Jan 28, 2005, at 23:55, friendVU admin wrote:

> When I execute this:
> "insert into comments
>    (
>     date_posted
>     )
>      (select  date_published
>    from xyz
>     )"
>
> I get :
> "ERROR:  column "date_posted" is of type timestamp without time zone 
> but expression is of type text
> HINT:  You will need to rewrite or cast the expression."
>
> Both dates are of type timesamp!

Could you post the output to \d xyz and \d comments from psql?

Michael Glaesemann
grzm myrealbox com