Skip site navigation (1) Skip section navigation (2)

Re: Cast NULL into Timestamp?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Cc: Wei Weng <wweng(at)kencast(dot)com>
Subject: Re: Cast NULL into Timestamp?
Date: 2004-12-11 05:11:28
Message-ID: 200412102111.28104.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-sql
Wei,

> insert into table temp (tempname, tempdate)
> select distinct 'tempname', null from some_other_relevant_table;

I don't think you're reporting the error exactly as it happened.  Try cutting 
and pasting your actual PSQL session into your e-mail.

Perhaps you are mixing up the column order?

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

pgsql-sql by date

Next:From: Joe ConwayDate: 2004-12-11 11:55:44
Subject: Re: Create Calendar
Previous:From: Kenneth GonsalvesDate: 2004-12-11 05:00:55
Subject: replacing mysql enum

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group