Re: Help with SQL updating not working. - Mailing list pgsql-novice

From Andreas Kretschmer
Subject Re: Help with SQL updating not working.
Date
Msg-id 20150519062351.GA11085@tux
Whole thread Raw
In response to Help with SQL updating not working.  (Paul Linehan <linehanp@tcd.ie>)
List pgsql-novice
Paul Linehan <linehanp@tcd.ie> wrote:

> Hi all,
>
> I'm trying to perform an update and having a bad brain day!
>
> It involves calculating the different between two times and inserting
> the difference into a third field
>
> Create the table
>
> test=# CREATE TABLE the_times (time1 time, time2 time, time_diff
> integer); -- time_diff is in seconds;
> CREATE TABLE

the time_diff - column are unnecessary, it can be calculated in the
select.


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°


pgsql-novice by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Help with SQL updating not working.
Next
From: Daniel Begin
Date:
Subject: Constraint exclusion in partitions