Re: Casting varchar to interval.?

On Monday 26 January 2004 14:43, Jim Wilson wrote:
> Is this a bug?  You can work around it by wrapping the varying in a trim()
> function (e.g. select trim(config_value)::interval from config).  I've
> solved another suspicious looking issue with that same kind of workaround.

The trim() is probably a coincidence (although I haven't tested extensively).
The issue is that there is a cast from text => interval but not from varchar.
The solution is to do something like:
  config_value::text::interval
This might be fixed in 7.4.1, but you'll need to check.

--
  Richard Huxton
  Archonet Ltd