Recently, while testing the application compatibility of the ODBC driver
in , we have come across a problem.    Some applications, specifically
MS Project, want to create tables using a bounded binary data type.
(i.e.  SQL_BINARY)   Up to now, we have mapped ODBC's SQL_BINARY to
PostgreSQL's BYTEA.    The problem is that when the application tries to
create the table.    Example:

    CREATE TABLE foo (bar BYTEA(100));

PostgreSQL errors, complaining about the "(".     I have created a
patch, which I am now testing, to allow this syntax for BYTEA.  It also,
truncates to the specified precision in the same fashion as does VARCHAR
while preserving its original behavior when a precision is not
specified.

1.   Are there any objections?

2.  It is very light weight and I would like to get the patch into
6.4.1.   Is this possible?   (I do not know the plans for this 6.4.1)


Mon, 07 Dec 1998 13:52:48 -0500
David Hartwig <daveh@insightdist.com>
Bytea(precision)