summaryrefslogtreecommitdiff
path: root/src/test/regress/sql/timestamptz.sql
AgeCommit message (Expand)Author
2023-03-18Add functions to do timestamptz arithmetic in a non-default timezone.Tom Lane
2023-02-27Rework pg_input_error_message(), now renamed pg_input_error_info()Michael Paquier
2023-02-20Detect overflow in timestamp[tz] subtraction.Tom Lane
2023-01-01Accept "+infinity" in date and timestamp[tz] input.Tom Lane
2022-12-09Convert datetime input functions to use "soft" error reporting.Tom Lane
2022-05-09Revert "Disallow infinite endpoints in generate_series() for timestamps."Tom Lane
2022-04-20Disallow infinite endpoints in generate_series() for timestamps.Tom Lane
2022-03-14Support "of", "tzh", and "tzm" format codes.Robert Haas
2021-07-28Disallow negative strides in date_bin()John Naylor
2021-07-22Fix division by zero error in date_binJohn Naylor
2021-04-06Change return type of EXTRACT to numericPeter Eisentraut
2021-03-30Add tests for date_part of epoch near upper bound of timestamp rangePeter Eisentraut
2021-03-30Add upper boundary tests for timestamp and timestamptz typesPeter Eisentraut
2021-03-29Clean up date_part tests a bitPeter Eisentraut
2021-03-24Add date_bin functionPeter Eisentraut
2020-12-15Clean up ancient test stylePeter Eisentraut
2019-12-22Avoid low-probability regression test failures in timestamp[tz] tests.Tom Lane
2019-12-12Remove redundant function calls in timestamp[tz]_part().Tom Lane
2019-09-16Support for FF1-FF6 datetime format patternsAlexander Korotkov
2019-06-30Remove explicit error handling for obsolete date/time valuesPeter Eisentraut
2018-11-14Add a timezone-specific variant of date_trunc().Tom Lane
2018-01-09Implement TZH and TZM timestamp format patternsAndrew Dunstan
2017-03-09Fix timestamptz regression test to still work with latest IANA zone data.Tom Lane
2017-01-30Add a regression test script dedicated to exercising system views.Tom Lane
2017-01-18Disable transforms that replaced AT TIME ZONE with RelabelType.Tom Lane
2016-09-05Add regression test coverage for non-default timezone abbreviation sets.Tom Lane
2016-09-02Don't require dynamic timezone abbreviations to match underlying time zone.Tom Lane
2016-03-30Remove just-added tests for to_timestamp(float8) with out-of-range inputs.Tom Lane
2016-03-29Allow to_timestamp(float8) to convert float infinity to timestamp infinity.Tom Lane
2016-03-17Fix assorted breakage in to_char()'s OF format option.Tom Lane
2016-03-16Be more careful about out-of-range dates and timestamps.Tom Lane
2014-11-19Don't require bleeding-edge timezone data in timestamptz regression test.Tom Lane
2014-10-16Support timezone abbreviations that sometimes change.Tom Lane
2014-05-13Be more wary in choice of timezone names to test make_timestamptz with.Tom Lane
2014-03-04Constructors for interval, timestamp, timestamptzAlvaro Herrera
2013-10-16Allow 5+ digit years for non-ISO timestamp/date strings, where appropriateBruce Momjian
2010-11-23Remove useless whitespace at end of linesPeter Eisentraut
2009-03-22Remove the datetime keywords ABSTIME and RELTIME, which we'd been treating asTom Lane
2008-09-11Tighten up to_date/to_timestamp so that they are more likely to rejectTom Lane
2008-05-25Adjust timestamp regression tests to prevent two low-probability failureTom Lane
2008-02-16Update timezone code to track the upstream changes since 2003. In particularTom Lane
2007-11-07Use "alternative" instead of "alternate" where it is clearer.Peter Eisentraut
2007-06-12Fix DecodeDateTime to allow timezone to appear before year. This hadTom Lane
2007-02-17Cleanup of to_char() patch.Bruce Momjian
2007-02-16Install a more correct fix in the timestamp and timestamptz regression tests:Alvaro Herrera
2007-02-16Fix the timestamptz test problem, by moving the tests that use theAlvaro Herrera
2007-02-16Add two new format fields for use with to_char(), to_date() andBruce Momjian
2006-10-17Fix up some problems in handling of zic-style time zone names in datetimeTom Lane
2006-07-25Remove hard-wired lists of timezone abbreviations in favor of providingTom Lane
2006-07-06Please find attached two patches for documentation and regression testsBruce Momjian