friendVU admin <maillist@friendvu.com> writes:
> 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!
I don't think so. Let's see the definitions of the comments and xyz
tables (\d in psql will do).
regards, tom lane