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

Is there a variant/anytype datatype in postgresql?

From: Rob Bochenek <rob_bochenek(at)evostc(dot)state(dot)ak(dot)us>
To: pgsql-general(at)postgresql(dot)org
Subject: Is there a variant/anytype datatype in postgresql?
Date: 2004-02-25 20:10:28
Message-ID: 000001c3fbdb$6a8979f0$1a193f92@robdesk (view raw, whole thread or download thread mbox)
Lists: pgsql-general
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


pgsql-general by date

Next:From: BenDate: 2004-02-25 20:16:08
Subject: Re: Repost: Syntax - or unavailability of same - for variable join??? Can anyone help?
Previous:From: Martijn van OosterhoutDate: 2004-02-25 19:21:08
Subject: Re: REINDEX issues

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