@@ -158,6 +158,8 @@ Dynahash portability improvements (Tom)
158158Remove OID's from some system tables (Tom)
159159Remove 'triggered data change violation' error check (Tom)
160160Optimize LIKE/ILIKE when using single-byte encodings (Tatsuo)
161+ New libpq function PQescapeBytea() escapes binary strings for use as
162+ SQL string literals
161163
162164Types
163165-----
@@ -167,7 +169,14 @@ BIT, BIT VARYING now returns error on too long input (Peter E)
167169New function bit_length() (Peter E)
168170INET, CIDR text conversion functions (Alex Pilosov)
169171INET, CIDR operators << and <<= indexable (Alex Pilosov)
170- Bytea comparison improvements, \### now requires three octal digits (Joe Conway)
172+ Bytea \### now requires valid three digit octal number
173+ Bytea comparison improvements, now supports =, !=, >, >=, <, and <=
174+ Bytea now supports btree indexes
175+ Bytea now supports LIKE, LIKE...ESCAPE, NOT LIKE, NOT LIKE...ESCAPE
176+ Bytea now supports string concatenation
177+ New Bytea functions - position(), substring, trim, btrim, and length
178+ New encode() function mode, 'escaped', converts minimally escaped
179+ bytea to/from text
171180Make trim/ltrim/rtrim/btrim/lpad/rpad/translate() multibyte aware (Tatsuo)
172181Formats with the correct number of columns for UNICODE in psql (Patrice)
173182Add pg_database_encoding_max_length() (Tatsuo)