Skip to content
Snippets Groups Projects
Select Git revision
  • benchmark-tools
  • postgres-lambda
  • master default
  • REL9_4_25
  • REL9_5_20
  • REL9_6_16
  • REL_10_11
  • REL_11_6
  • REL_12_1
  • REL_12_0
  • REL_12_RC1
  • REL_12_BETA4
  • REL9_4_24
  • REL9_5_19
  • REL9_6_15
  • REL_10_10
  • REL_11_5
  • REL_12_BETA3
  • REL9_4_23
  • REL9_5_18
  • REL9_6_14
  • REL_10_9
  • REL_11_4
23 results

TODO.html

Blame
    • Bruce Momjian's avatar
      5894e7e3
      Add items: · 5894e7e3
      Bruce Momjian authored
      > * Prevent to_char() on interval from returning meaningless values
      >
      >   For example, to_char('1 month', 'mon') is meaningless.  Basically,
      >   most date-related parameters to to_char() are meaningless for
      >   intervals because interval is not anchored to a date.
      >
      > * Allow to_char() on interval values to accumulate the highest unit
      >   requested
      >
      > 	o to_char(INTERVAL '1 hour 5 minutes', 'MI') => 65
      > 	o to_char(INTERVAL '43 hours 20 minutes', 'MI' ) => 2600
      > 	o to_char(INTERVAL '43 hours 20 minutes', 'WK:DD:HR:MI') => 0:1:19:20
      > 	o to_char(INTERVAL '3 years 5 months','MM') => 41
      >
      >   Some special format flag would be required to request such
      >   accumulation.  Such functionality could also be added to EXTRACT.
      >   Prevent accumulation that crosses the month/day boundary because of
      >   the uneven number of days in a month.
      >
      5894e7e3
      History
      Add items:
      Bruce Momjian authored
      > * Prevent to_char() on interval from returning meaningless values
      >
      >   For example, to_char('1 month', 'mon') is meaningless.  Basically,
      >   most date-related parameters to to_char() are meaningless for
      >   intervals because interval is not anchored to a date.
      >
      > * Allow to_char() on interval values to accumulate the highest unit
      >   requested
      >
      > 	o to_char(INTERVAL '1 hour 5 minutes', 'MI') => 65
      > 	o to_char(INTERVAL '43 hours 20 minutes', 'MI' ) => 2600
      > 	o to_char(INTERVAL '43 hours 20 minutes', 'WK:DD:HR:MI') => 0:1:19:20
      > 	o to_char(INTERVAL '3 years 5 months','MM') => 41
      >
      >   Some special format flag would be required to request such
      >   accumulation.  Such functionality could also be added to EXTRACT.
      >   Prevent accumulation that crosses the month/day boundary because of
      >   the uneven number of days in a month.
      >