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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
