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
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
friendVU admin [EMAIL PROTECTED] 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