1. 06 Aug, 2000 1 commit
    • Thomas G. Lockhart's avatar
      Implement LIKE/ESCAPE. Change parser to use like()/notlike() · 259489ba
      Thomas G. Lockhart authored
       rather than the "~~" operator; this made it easy to add ESCAPE features.
      Implement ILIKE, NOT ILIKE, and the ESCAPE clause for them.
       afaict this is not MultiByte clean, but lots of other stuff isn't either.
      Fix up underlying support code for LIKE/NOT LIKE.
       Things should be faster and does not require internal string copying.
      Update regression test to add explicit checks for
       LIKE/NOT LIKE/ILIKE/NOT ILIKE.
      Remove colon and semi-colon operators as threatened in 7.0.
      Implement SQL99 COMMIT/AND NO CHAIN.
       Throw elog(ERROR) on COMMIT/AND CHAIN per spec
       since we don't yet support it.
      Implement SQL99 CREATE/DROP SCHEMA as equivalent to CREATE DATABASE.
       This is only a stopgap or demo since schemas will have another
       implementation soon.
      Remove a few unused production rules to get rid of warnings
       which crept in on the last commit.
      Fix up tabbing in some places by removing embedded spaces.
      259489ba
  2. 17 Jan, 2000 1 commit
  3. 05 Jan, 2000 1 commit
    • Thomas G. Lockhart's avatar
      Clean up format of tests. · 4c4e68dc
      Thomas G. Lockhart authored
      Remove older "::" type coersion syntax in favor of extended SQL92 style.
      Include a few new tests for datetime/timespan arithmetic.
      4c4e68dc
  4. 29 May, 1998 1 commit
    • Thomas G. Lockhart's avatar
      Add test for UNION. · 5812d512
      Thomas G. Lockhart authored
      Add additional tests in strings for conversions of the "name" data type.
      Test SQL92 string functions such as SUBSTRING() and POSITION().
      5812d512
  5. 01 Dec, 1997 1 commit