aboutsummaryrefslogtreecommitdiff
path: root/src/backend/utils/adt/arrayfuncs.c
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2010-12-28 22:49:57 -0500
committerTom Lane <tgl@sss.pgh.pa.us>2010-12-28 22:50:30 -0500
commitd5b2587c20854044277c9616b8582b5f1f19d197 (patch)
tree708af0bd39b3742b83e5932804a8e7dfaabd7f90 /src/backend/utils/adt/arrayfuncs.c
parent370a89969623647612a0d5727a143799d3b33b66 (diff)
downloadpostgresql-d5b2587c20854044277c9616b8582b5f1f19d197.tar.gz
postgresql-d5b2587c20854044277c9616b8582b5f1f19d197.zip
Avoid unexpected conversion overflow in planner for distant date values.
The "date" type supports a wider range of dates than int64 timestamps do. However, there is pre-int64-timestamp code in the planner that assumes that all date values can be converted to timestamp with impunity. Fortunately, what we really need out of the conversion is always a double (float8) value; so even when the date is out of timestamp's range it's possible to produce a sane answer. All we need is a code path that doesn't try to force the result into int64. Per trouble report from David Rericha. Back-patch to all supported versions. Although this is surely a corner case, there's not much point in advertising a date range wider than timestamp's if we will choke on such values in unexpected places.
Diffstat (limited to 'src/backend/utils/adt/arrayfuncs.c')
0 files changed, 0 insertions, 0 deletions