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