1. 09 May, 1998 1 commit
  2. 27 Apr, 1998 1 commit
    • Marc G. Fournier's avatar
      From: t-ishii@sra.co.jp · f554af0a
      Marc G. Fournier authored
      Hi, here are patches I promised (against 6.3.2):
      
      * character_length(), position(), substring() are now aware of
                multi-byte characters
      * add octet_length()
      * add --with-mb option to configure
      * new regression tests for EUC_KR
        (contributed by "Soonmyung. Hong" <hong@lunaris.hanmesoft.co.kr>)
      * add some test cases to the EUC_JP regression test
      * fix problem in regress/regress.sh in case of System V
      * fix toupper(), tolower() to handle 8bit chars
      
      note that:
      
      o  patches for both configure.in and configure are
      included. maybe the one for configure is not necessary.
      
      o pg_proc.h was modified to add octet_length(). I used OIDs
      (1374-1379) for that. Please let me know if these numbers are not
      appropriate.
      f554af0a
  3. 26 Apr, 1998 1 commit
  4. 07 Apr, 1998 1 commit
  5. 30 Mar, 1998 1 commit
    • Bruce Momjian's avatar
      The following uuencoded, gzip'd file will ... · 57b59664
      Bruce Momjian authored
      1. Remove the char2, char4, char8 and char16 types from postgresql
      2. Change references of char16 to name in the regression tests.
      3. Rename the char16.sql regression test to name.sql.  4. Modify
      the regression test scripts and outputs to match up.
      
      Might require new regression.{SYSTEM} files...
      
      Darren King
      57b59664
  6. 26 Feb, 1998 1 commit
  7. 10 Feb, 1998 1 commit
  8. 02 Feb, 1998 1 commit
  9. 16 Jan, 1998 1 commit
  10. 01 Jan, 1998 1 commit
  11. 23 Dec, 1997 1 commit
  12. 16 Dec, 1997 1 commit
  13. 15 Nov, 1997 1 commit
  14. 30 Oct, 1997 1 commit
  15. 25 Oct, 1997 1 commit
  16. 09 Oct, 1997 1 commit
  17. 20 Sep, 1997 1 commit
  18. 08 Sep, 1997 3 commits
  19. 07 Sep, 1997 1 commit
  20. 19 Aug, 1997 1 commit
  21. 29 Jul, 1997 1 commit
    • Thomas G. Lockhart's avatar
      Add new routines. · e89d139d
      Thomas G. Lockhart authored
      Change definition for isreltime().
      Change some names of #define constants to avoid conflicts with the yacc parser.
      e89d139d
  22. 23 Jun, 1997 1 commit
  23. 14 May, 1997 1 commit
  24. 11 May, 1997 1 commit
  25. 27 Apr, 1997 1 commit
  26. 15 Apr, 1997 1 commit
    • Marc G. Fournier's avatar
      From: Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov> · 88d74046
      Marc G. Fournier authored
      Subject: [HACKERS] Money integration patches
      
      Here are patches to integrate the money data type. I have included
      some math and aggregate functions and have made the locale support optional
      by #ifdef USE_LOCALE bracketing of functions.
      
      Modules affected are:
      builtins.h.patch
      cash.c.patch
      cash.h.patch
      main.c.patch
      pg_aggregate.h.patch
      pg_operator.h.patch
      pg_proc.h.patch
      pg_type.h.patch
      
      I changed the data type to be pass-by-reference rather than by-value
      to pave the way for a larger internal representation (64-bit ints?).
      Also, I changed the tabbing of cash.c and cash.h to match most of
      the other Postgres source code files (4 space indent, 8 spaces == 1 tab).
      
      The locale stuff should be tested under another convention (Russian?)
      but I don't know what the correct results should be so perhaps someone
      else can give them a try. Will update docs and regression tests in
      the next few days.
      88d74046
  27. 02 Apr, 1997 1 commit
    • Marc G. Fournier's avatar
      From: Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov> · 2ab34dfe
      Marc G. Fournier authored
      Subject: [HACKERS] More date time functions
      
      Here are some additional patches mostly related to the date and time
      data types. It includes some type conversion routines to move between
      the different date types and some other date manipulation routines such
      as date_part(units,datetime).
      
      I noticed Edmund Mergl et al's neat trick for getting function overloading
      for builtin functions, so started to use that for the date and time stuff.
      Later, if someone figures out how to get function overloading directly
      for internal C code, then we can move to that technique.
      
      These patches include documentation updates (don't faint!) for the built-in
      man page. Doesn't yet include mention of timestamp, since I don't know
      much about it and since it may change a bit to become a _real_ ANSI timestamp
      which would include parser support for the declaration syntax (what do you
      think, Dan?).
      
      The patches were developed on the 970330 release, but have been rebuilt
      off of the 970402 release. The first patch below is to get libpq to compile,
      on my Linux box, but is not related to the rest of the patches and you can
      choose not to apply that one at this time. Thanks in advance, scrappy!
      2ab34dfe
  28. 25 Mar, 1997 1 commit
    • Marc G. Fournier's avatar
      From: "D'Arcy J.M. Cain" <darcy@druid.net> · 07038148
      Marc G. Fournier authored
      Subject: [HACKERS] backend/utils/adt/timestamp.c
      
      Back to this timezone stuff.  The struct tm has a field (tm_gmtoff) which
      is the offset from UTC (GMT is archaic BTW) in seconds.  Is this the
      value you are looking for when you use timezone?  Note that this applies
      to NetBSD but it does not appear to be in either ANSI C or POSIX.  This
      looks like one of those things that is just going to have to be hand
      coded for each platform.
      
      Why not just store the values in UTC and use localtime instead of
      gmtime when retrieving the value?
      
      Also, you assume the time is returned as a 4 byte integer.  In fact,
      there is not even any requirement that time be an integral value.  You
      should use time_t here.
      
      The input function seems unduly restrictive.  Somewhere in the sources
      there is an input function that allows words for months.  Can't we do
      the same here?
      
      There is a standard function, difftime, for subtracting two times.  It
      deals with cases where time_t is not integral.  There is, however, a
      small performance hit since it returns a double and I don't believe
      there is any system currently which uses anything but an integral for
      time_t.  Still, this is technically the correct and portable thing to do.
      
      The returns from the various comparisons should probably be a bool.
      07038148
  29. 14 Mar, 1997 1 commit
  30. 12 Mar, 1997 1 commit
  31. 09 Mar, 1997 1 commit
  32. 19 Feb, 1997 1 commit
  33. 16 Nov, 1996 1 commit
  34. 10 Nov, 1996 1 commit
  35. 04 Nov, 1996 3 commits
  36. 03 Nov, 1996 1 commit