Re: reltime with NULL fields crashes backend

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: cit(at)tag-ltd(dot)spb(dot)ru, pgsql-bugs(at)postgresql(dot)org
Subject: Re: reltime with NULL fields crashes backend
Date: 2001-04-11 13:44:34
Message-ID: 3AD45FC2.11F937BC@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> Long Description
> I use expression like int4(reltime(<interval-field>)) to get interval length in seconds. When <interval-field> is NULL backend crashes (psql session):

This is likely fixed in the upcoming 7.1, since NULL handling has been
greatly improved for "by value" types like reltime. However, you *could*
be doing this as

select date_part('epoch', <interval-field>) ...

hth

- Thomas

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2001-04-11 15:26:18 Re: When I install postgresql using rpm it is ok. When I compile the fonts and execute the initdb hapen a Error: unknown type 'ame'.
Previous Message Thomas Lockhart 2001-04-11 13:36:17 Re: result of conversion to timestamp is shifted 1 minute back