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: AANLkTinpA_J0+ZuebqFmeiFR9HTXSunkCBrFCzNnKb-r@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
@Steve:

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:
> ...as 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-2014 The PostgreSQL Global Development Group