Re: bytea HISTORY updates - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: bytea HISTORY updates
Date
Msg-id 200111210316.fAL3GJ113017@candle.pha.pa.us
Whole thread Raw
In response to bytea HISTORY updates  (Joe Conway <joseph.conway@home.com>)
List pgsql-patches
Done, but didn't we use to allow \0 for NULL, while we now require \000?

---------------------------------------------------------------------------

> Bruce,
>
> Please update HISTORY entries for bytea changes.
>
> Remove:
>
> Bytea comparison improvements, \### now requires three octal digits
>
> Add:
>
> Bug Fixes
>   bytea \### now requires valid three digit octal number
>
> Types
>   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
>
> Enhancements
>   New libpq function, PQescapeBytea escapes binary string suitably for
>      use as a SQL string literal
>
>
> Joe
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-patches by date:

Previous
From: Joe Conway
Date:
Subject: Re: bytea datatype documentation patch
Next
From: Bruce Momjian
Date:
Subject: Re: bytea HISTORY updates