Postgres Pro
Downloads
Home   >   mailing lists

Re: reltime with NULL fields crashes backend - Mailing list pgsql-bugs

From Thomas Lockhart
Subject Re: reltime with NULL fields crashes backend
Date
Msg-id 3AD45FC2.11F937BC@alumni.caltech.edu
Whole thread Raw
In response to reltime with NULL fields crashes backend  (pgsql-bugs@postgresql.org)
List pgsql-bugs
Tree view 
> Long Description
> I use expression like int4(reltime(<interval-field>)) to get interval length in seconds. When <interval-field> is
NULLbackend 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

pgsql-bugs by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: result of conversion to timestamp is shifted 1 minute back
Next
From: Peter Eisentraut
Date:
Subject: 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'.