diff options
| author | Bruce Momjian <bruce@momjian.us> | 2001-11-21 03:15:54 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2001-11-21 03:15:54 +0000 |
| commit | 76c879cd9a0f6bb8b49b05e8e50e1106bf6eba11 (patch) | |
| tree | d53343543a8f50578ccdbefcaed1e63baeadb87b | |
| parent | 3345da53ad5b2daf8232770c34bef38124cc4fcf (diff) | |
| download | postgresql-76c879cd9a0f6bb8b49b05e8e50e1106bf6eba11.tar.gz postgresql-76c879cd9a0f6bb8b49b05e8e50e1106bf6eba11.zip | |
Update for bytea, from Joe Conway
| -rw-r--r-- | HISTORY | 11 |
1 files changed, 10 insertions, 1 deletions
@@ -158,6 +158,8 @@ Dynahash portability improvements (Tom) Remove OID's from some system tables (Tom) Remove 'triggered data change violation' error check (Tom) Optimize LIKE/ILIKE when using single-byte encodings (Tatsuo) +New libpq function PQescapeBytea() escapes binary strings for use as + SQL string literals Types ----- @@ -167,7 +169,14 @@ BIT, BIT VARYING now returns error on too long input (Peter E) New function bit_length() (Peter E) INET, CIDR text conversion functions (Alex Pilosov) INET, CIDR operators << and <<= indexable (Alex Pilosov) -Bytea comparison improvements, \### now requires three octal digits (Joe Conway) +Bytea \### now requires valid three digit octal number +Bytea comparison improvements, now supports =, !=, >, >=, <, and <= +Bytea now supports btree indexes +Bytea now supports LIKE, LIKE...ESCAPE, NOT LIKE, NOT LIKE...ESCAPE +Bytea now supports string concatenation +New Bytea functions - position(), substring, trim, btrim, and length +New encode() function mode, 'escaped', converts minimally escaped + bytea to/from text Make trim/ltrim/rtrim/btrim/lpad/rpad/translate() multibyte aware (Tatsuo) Formats with the correct number of columns for UNICODE in psql (Patrice) Add pg_database_encoding_max_length() (Tatsuo) |