Both oracle and MS-SQL server have a variant datatype which allows the insertion of any data type except BLOBs. A short integer is concatenated onto the front of the piece of data being inserted into the variant (SQL Server) or anytype(Oracle) which defines the type of data in the field. Does Postgresql have anything like this or is there anyway to create such functionality? I’m working on a data management system for archiving heterogeneous data sets and my initial design incorporates this variant data type.
Rob Bochenek Data Systems Manager Exxon Valdez Oil Spill Trustee Council 441 W 5th Avenue, Suite 500 Phone (907) 265-9360
|