Re: Hrm. interval() function?

> >> ler=# select interval('6 months');
> >> ERROR:  parser: parse error at or near "'6 months'" at character 17
> >> ler=# select interval('6 months'::text);
> >> ERROR:  parser: parse error at or near "'6 months'" at character 17
> >> ler=#
> >
> > Try:
> >
> > select "interval"('6 months');
> >
> That works, but is non-intuitive.  I assume this is a reserved word issue?

It's been like that since 7.2 introduced sql standard syntax for various
timestmap things.

> Can it be fixed?

Nope - the correct way to use that function is this:

select interval '6 months';

Chris