Postgres Pro
Downloads
Home   >   mailing lists

Re: Hrm. interval() function? - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Hrm. interval() function?
Date
Msg-id 0d8d01c2e9d4$54f0f010$6500a8c0@fhp.internal
Whole thread Raw
In response to Hrm. interval() function?  (Larry Rosenman <ler@lerctr.org>)
Responses Re: Hrm. interval() function?  (Larry Rosenman <ler@lerctr.org>)
List pgsql-hackers
Tree view 
> 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');

Chris

pgsql-hackers by date:

Previous
From: Larry Rosenman
Date:
Subject: Re: Upgrading the backend's error-message infrastructure
Next
From: Larry Rosenman
Date:
Subject: Re: Hrm. interval() function?