Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3E04147669D for ; Fri, 17 Jan 2003 10:03:13 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 6C3114762AD for ; Fri, 17 Jan 2003 10:03:12 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h0HF345u011793; Fri, 17 Jan 2003 10:03:04 -0500 (EST) To: Julian Scarfe Cc: Oliver Vecernik , pgsql-sql@postgresql.org Subject: Re: sum(time) problem In-reply-to: References: Comments: In-reply-to Julian Scarfe message dated "Fri, 17 Jan 2003 13:13:31 +0000" Date: Fri, 17 Jan 2003 10:03:04 -0500 Message-ID: <11792.1042815784@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/277 X-Sequence-Number: 11142 Julian Scarfe writes: >> It seems I've chosen the wrong type. Or is there another solution? > Correct diagnosis. You need the "interval" type, not the "time" type for > your second field. Interval is a time difference between two timestamps, > for example the time between the start and the finish of a race. Right. "time" is intended for time-of-day values; so taking the sum would be a nonsensical operation. regards, tom lane