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