From: Tom Lane <tgl@sss.pgh.pa.us>
To: friendVU admin <maillist@friendvu.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: error: cast the timestam expression
Date: Fri, 28 Jan 2005 10:04:12 -0500
Message-ID: <29815.1106924652@sss.pgh.pa.us> (raw)
In-Reply-To: <41FA527E.9050005@friendvu.com>
References: <41FA527E.9050005@friendvu.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, maillist@friendvu.com
Subject: Re: error: cast the timestam expression
In-Reply-To: <29815.1106924652@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox