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

Re: interval conversion bug

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Andrzej Wojtaszek <Andrzej(dot)Wojtaszek(at)pro-futuro(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: interval conversion bug
Date: 2004-11-25 16:32:44
Message-ID: 20041125082954.N43320@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Thu, 25 Nov 2004, Andrzej Wojtaszek wrote:

> I'm afraid that operator ::interval not working propertly
> example:
>
> select 1
> ######################
> select now() + (1||' day')::interval;
> working propertly
> ######################

This is a text -> interval conversion

> select 3
> ######################
> select my_name
>  now() +  (test('12'))::interval
> from table1
> ######################

This is a varchar -> interval conversion.

It looks like 7.4 doesn't have the latter conversion and requires you to
go through text to make the conversion. 8.0 appears to add direct
conversions from varchar.

In response to

pgsql-bugs by date

Next:From: OvcharenkoDate: 2004-11-26 08:39:38
Subject: Build libpq for win32
Previous:From: Tom LaneDate: 2004-11-25 16:25:34
Subject: Re: interval conversion bug

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