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.
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
