Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Peter EisentrautDate: 2001-04-11 15:26:18
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'.
Previous:From: Thomas LockhartDate: 2001-04-11 13:36:17
Subject: Re: result of conversion to timestamp is shifted 1 minute back

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group