> >> 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