EBIHARA, Yuichiro wrote:
Hi,
I'm developing a software that supports several RDBMSs including PostgreSQL.
The software needs an ability to handle large objects and now it uses 'bytea' datatype for binary
data and 'text' for text data.
But for portability, I'd rather use BLOB and CLOB defined by the SQL standards indeed.
Is there any plan to support BLOB and CLOB in future releases?
Looking at the spec, and postgresql's implementation, I can't see much
reason you couldn't just use a domain to declare that a bytea is a blob
and varchar is a clob.
Unless there's some spefici thing you need I'm not seeing.
