Omega359 commented on issue #11822: URL: https://github.com/apache/datafusion/issues/11822#issuecomment-2327069473
> Sky is the limit :-) I think postgres supports all kinds of intervals (except nanos since those are not supported by postgresql), but they handle `generate_series` differently I think. Instead of using `date`, they use `timestamp` , so `'2021-01-01'::date` gets casted to `2021-01-01 00:00:00.000000 +00:00`. Personally I think that makes more sense, since `timestamp` is more general than `date`. If you want `date` back from `generate_series`, the timestamp can be casted to a `date` I thought about that as well though my main concern with that would that it would be an api change for these UDF's since the output type would change unexpectedly between releases. It would make the implementation easier though -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
