分类:
2009-08-29 20:55:03
This eliminates the need for explicit casting in some situations.
这就避免了一些需要显式类型转换的情况。
on/off 作为逻辑类型值。
许输入数据类型时在 NaN 两边有空格。
Previously these were interpreted as 1 BC. (Note: years 0 and 00 are still assumed to be the year 2000.)
以前这些会解释为公元前一前(注意:0 年和 00 年被当做 2000 年接受)
For example, INTERVAL '1' YEAR now does what it's supposed to.
例如: INTERVAL '1' YEAR 现在就像你猜的一样,表示一年。
Formerly the precision had to be specified after the keyword interval. (For backwards compatibility, this syntax is still supported, though deprecated.) Data type definitions will now be output using the standard format.
之前精度要在 interval 关键字后指定。(为了向后兼容,这种语法仍被支持,不过不建议 这样用。)数据类型定义现在会使用标准输出格式。
For example, INTERVAL 'P1Y2M3DT4H5M6.7S' is now supported. 例如,现在支持 INTERVAL 'P1Y2M3DT4H5M6.7S'
Valid values are: postgres, postgres_verbose, sql_standard, iso_8601. This setting also controls the handling of negative interval input when only some fields have positive/negative designations.
可用的值有: postgres, postgres_verbose, sql_standard, iso_8601。当只有一部分字 段有正负号时,该设置也控制负 interval。
Formerly PostgreSQL attempted to determine a data type for the ARRAY[] construct without reference to the ensuing cast. This could fail unnecessarily in many cases, in particular when the ARRAY[] construct was empty or contained only ambiguous entries such as NULL. Now the cast is consulted to determine the type that the array elements must be.
以 前 PostgreSQL 在不引用确定转换的情况下尝试判定 ARRAY[] 构造器的类型。这在很多 情况下可能会导致不必要的错误,特别是 ARRAY[] 构造器为空或只有一个 NULL 之类的不 定值的情况下。现在类型转换可以根据必要的类型定义明确数线元素的类型。
This is the opposite of array_agg().
这是 array_agg() 的逆操作。