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

Re: inserting a NULL timestamp

From: Robert Poor <rdpoor(at)gmail(dot)com>
To: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: inserting a NULL timestamp
Date: 2011-03-29 17:18:17
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

On Tue, Mar 29, 2011 at 10:09, Steve Crawford
<scrawford(at)pinpointresearch(dot)com> wrote:
> It's the select part that is causing your trouble. Try casting the null to a
> timestamp:
> cost, null::timestamp as start_time...

Bingo.  Perfect - thanks.

In response to

pgsql-novice by date

Next:From: Robert PoorDate: 2011-03-29 20:41:55
Subject: updating records in table A from selected records in table B
Previous:From: Steve CrawfordDate: 2011-03-29 17:09:54
Subject: Re: inserting a NULL timestamp

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