X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 10DF33A6122
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 28 Jan 2005 14:56:11 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 57813-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 28 Jan 2005 14:55:59 +0000 (GMT)
Received: from mail.mailsnare.net (v187.mailsnare.net [206.246.200.187])
	by svr1.postgresql.org (Postfix) with ESMTP id 337D03A62A3
	for <pgsql-sql@postgresql.org>; Fri, 28 Jan 2005 14:56:02 +0000 (GMT)
Received: from [172.16.1.33] (adsl-68-94-25-176.dsl.rcsntx.swbell.net
	[68.94.25.176])
	by mail.mailsnare.net (Postfix) with ESMTP id 56BE9D698
	for <pgsql-sql@postgresql.org>; Fri, 28 Jan 2005 14:55:58 +0000 (UTC)
Message-ID: <41FA527E.9050005@friendvu.com>
Date: Fri, 28 Jan 2005 08:55:58 -0600
From: friendVU admin <maillist@friendvu.com>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: error: cast the timestam expression
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by ClamAV at mailsnare.net
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=
X-Spam-Level: 
X-Archive-Number: 200501/307
X-Sequence-Number: 20095

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 searched how to cast, and can't find it.

What is the syntax to cast a timestamp to a timestamp?
tia,
.V