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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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