Tom, On Thu, Jun 18, 2020 at 7:07 PM Tom Lane <t...@sss.pgh.pa.us> wrote: > Oleg Bartunov <obartu...@postgrespro.ru> writes: > > The problem is that we tried to find a trade-off between standard and > > postgres implementation, for example, in postgres CAST allows NaN and > > Inf, and SQL Standard requires .double should works as CAST. > > As I said, I think this is a fundamental misreading of the standard. > The way I read it is that it requires the set of values that are legal > according to the standard to be processed the same way as CAST would.
Thank you for your answer. I'm trying to understand your point. Standard claims that .double() method should behave the same way as CAST to double. However, standard references the standard behavior of CAST here, not behavior of your implementation of CAST. So, if we extend the functionality of standard CAST in our implementation, that doesn't automatically mean we should extend the .double() jsonpath method in the same way. Is it correct? ------ Alexander Korotkov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company
