Tom Lane wrote:
Joe Conway <[EMAIL PROTECTED]> writes:
... My hope was that eventually anyarray I/O functions could eliminate the need to create an array type for every data type you wanted to use as an array element.

Interesting thought, but then how do you declare the type of an array
column, or the type of a function argument that's not supposed to range
over every array type?  If we can't use an OID to identify a data type
completely, we're going to have lots of problems.


You only really need two pieces of information to uniquely identify an array data type -- the OID of the (leaf-node) scalar elements, and the fact that what you have is an array. Even if it is a nested structure of arrays, by recursing (max 5 times), you can eventually find the scalar elements. Last year I played around with this and had it partially working, but then got too busy to pursue it further.

Joe



---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org

Reply via email to