1. 05 Nov, 2007 2 commits
  2. 30 Oct, 2007 1 commit
  3. 25 Oct, 2007 1 commit
    • Tom Lane's avatar
      Fix ALTER SEQUENCE so that it does not affect the value of currval() for · 9ddfe034
      Tom Lane authored
      the sequence.  Also, make setval() with is_called = false not affect the
      currval state, either.  Per report from Kris Jurka that an implicit
      ALTER SEQUENCE OWNED BY unexpectedly caused currval() to become valid.
      Since this isn't 100% backwards compatible, it will go into HEAD only;
      I'll put a more limited patch into 8.2.
      9ddfe034
  4. 23 Oct, 2007 1 commit
    • Tom Lane's avatar
      Rename and slightly redefine the default text search parser's "word" · dbaec70c
      Tom Lane authored
      categories, as per discussion.  asciiword (formerly lword) is still
      ASCII-letters-only, and numword (formerly word) is still the most general
      mixed-alpha-and-digits case.  But word (formerly nlword) is now
      any-group-of-letters-with-at-least-one-non-ASCII, rather than all-non-ASCII as
      before.  This is no worse than before for parsing mixed Russian/English text,
      which seems to have been the design center for the original coding; and it
      should simplify matters for parsing most European languages.  In particular
      it will not be necessary for any language to accept strings containing digits
      as being regular "words".  The hyphenated-word categories are adjusted
      similarly.
      dbaec70c
  5. 22 Oct, 2007 1 commit
    • Tom Lane's avatar
      Adjust ts_debug's output as per my proposal of yesterday: show the · 3e17ef1c
      Tom Lane authored
      active dictionary and its output lexemes as separate columns, instead
      of smashing them into one text column, and lowercase the column names.
      Also, define the output rowtype using OUT parameters instead of a
      composite type, to be consistent with the other built-in functions.
      3e17ef1c
  6. 21 Oct, 2007 1 commit
  7. 13 Oct, 2007 1 commit
  8. 11 Oct, 2007 1 commit
  9. 07 Oct, 2007 1 commit
  10. 24 Sep, 2007 1 commit
  11. 19 Sep, 2007 1 commit
  12. 18 Sep, 2007 1 commit
    • Andrew Dunstan's avatar
      Close previously open holes for invalidly encoded data to enter the · 55613bf9
      Andrew Dunstan authored
      database via builtin functions, as recently discussed on -hackers.
      
      chr() now returns a character in the database encoding. For UTF8 encoded databases
      the argument is treated as a Unicode code point. For other multi-byte encodings
      the argument must designate a strict ascii character, or an error is raised,
      as is also the case if the argument is 0.
      
      ascii() is adjusted so that it remains the inverse of chr().
      
      The two argument form of convert() is gone, and the three argument form now
      takes a bytea first argument and returns a bytea. To cover this loss three new
      functions are introduced:
      . convert_from(bytea, name) returns text - converts the first argument from the
        named encoding to the database encoding
      . convert_to(text, name) returns bytea - converts the first argument from the
        database encoding to the named encoding
      . length(bytea, name) returns int - gives the length of the first argument in
        characters in the named encoding
      55613bf9
  13. 14 Sep, 2007 3 commits
  14. 31 Aug, 2007 2 commits
  15. 29 Aug, 2007 2 commits
  16. 21 Aug, 2007 1 commit
  17. 19 Aug, 2007 2 commits
  18. 13 Aug, 2007 1 commit
  19. 11 Aug, 2007 1 commit
    • Tom Lane's avatar
      Code review for regexp_matches/regexp_split patch. Refactor to avoid assuming · 1b706193
      Tom Lane authored
      that cached compiled patterns will still be there when the function is next
      called.  Clean up looping logic, thereby fixing bug identified by Pavel
      Stehule.  Share setup code between the two functions, add some comments, and
      avoid risky mixing of int and size_t variables.  Clean up the documentation a
      tad, and accept all the flag characters mentioned in table 9-19 rather than
      just a subset.
      1b706193
  20. 18 Jul, 2007 1 commit
  21. 06 Jun, 2007 1 commit
    • Tom Lane's avatar
      Fix up text concatenation so that it accepts all the reasonable cases that · 2d4db367
      Tom Lane authored
      were accepted by prior Postgres releases.  This takes care of the loose end
      left by the preceding patch to downgrade implicit casts-to-text.  To avoid
      breaking desirable behavior for array concatenation, introduce a new
      polymorphic pseudo-type "anynonarray" --- the added concatenation operators
      are actually text || anynonarray and anynonarray || text.
      2d4db367
  22. 30 May, 2007 1 commit
  23. 21 May, 2007 1 commit
    • Peter Eisentraut's avatar
      XPath fixes: · 3963574d
      Peter Eisentraut authored
       - Function renamed to "xpath".
       - Function is now strict, per discussion.
       - Return empty array in case when XPath expression detects nothing
         (previously, NULL was returned in such case), per discussion.
       - (bugfix) Work with fragments with prologue: select xpath('/a',
         '<?xml version="1.0"?><a /><b />'); // now XML datum is always wrapped
         with dummy <x>...</x>, XML prologue simply goes away (if any).
       - Some cleanup.
      
      Nikolay Samokhvalov
      
      Some code cleanup and documentation work by myself.
      3963574d
  24. 07 May, 2007 2 commits
  25. 07 Apr, 2007 2 commits
  26. 05 Apr, 2007 1 commit
  27. 02 Apr, 2007 2 commits
  28. 01 Apr, 2007 1 commit
  29. 25 Mar, 2007 1 commit
  30. 20 Mar, 2007 1 commit
    • Neil Conway's avatar
      Add three new regexp functions: regexp_matches, regexp_split_to_array, · 9eb78bee
      Neil Conway authored
      and regexp_split_to_table. These functions provide access to the
      capture groups resulting from a POSIX regular expression match,
      and provide the ability to split a string on a POSIX regular
      expression, respectively. Patch from Jeremy Drake; code review by
      Neil Conway, additional comments and suggestions from Tom and
      Peter E.
      
      This patch bumps the catversion, adds some regression tests,
      and updates the docs.
      9eb78bee
  31. 20 Feb, 2007 1 commit