[EMAIL PROTECTED] wrote: > Eric Lu ([EMAIL PROTECTED]) reports a bug with a severity of 4 > The lower the number the more severe it is. > > Short Description > bytea data type problem/bug > > Long Description > Hi, > > It happens when I was trying to test the avalaibility of the new binary data type ><bytea> comes with ver 7.2. > As I read from the document, <bytea> will take data from '\\000' (0d)to '\\377' >(255d). Although it saves data more than one byte, it looks odd to me that the first >digit of the binary data could never be greater than '3'. > Is it the way it should be? > Thanks! > > Eric Lu >
The escaped values must be three-digits, octal (i.e. base 8) numbers, and in the range of 0 - 255 in decimal (base 10). Only the digits 0 - 7 are defined, and 377 octal == 255 decimal is the maximum allowable value. Anything starting with 4 - 7 (e.g. 400 octal == 256 decimal) is too big. Joe ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html