Skip site navigation (1) Skip section navigation (2)

bytea HISTORY updates

From: Joe Conway <joseph(dot)conway(at)home(dot)com>
To: "pgsql-patches(at)postgresql(dot)org" <pgsql-patches(at)postgresql(dot)org>
Subject: bytea HISTORY updates
Date: 2001-11-21 02:34:46
Message-ID: 3BFB12C6.8090208@home.com (view raw or flat)
Thread:
Lists: pgsql-patches
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


Responses

pgsql-patches by date

Next:From: Joe ConwayDate: 2001-11-21 02:41:41
Subject: Re: bytea datatype documentation patch
Previous:From: Joe ConwayDate: 2001-11-20 23:02:55
Subject: Re: Cross-references (was [PATCHES] PQescapeBytea documentation patch)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group