Re: SQL99 ARRAY support proposal - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: SQL99 ARRAY support proposal
Date
Msg-id 00b501c2e76d$207204f0$6500a8c0@fhp.internal
Whole thread Raw
In response to SQL99 ARRAY support proposal  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers
> So if I understand correctly, all instances of anyarray and anyelement 
> in a function definition would need to be self-consistent, but the group 
> could represent essentially any datatype with its corresponding array 
> type. If we need more than one of these self consistent groups, we could 
> resort to anyarray1/anyelement1, etc. Does this sound correct?
> 
> Also, an implementation question: if I have a type oid for an element, 
> what is the preferred method for determining the corresponding array? 
> I'm thinking that the most efficient method might be to use the 
> element-type name with a '_' prepended to get the array-type oid, but 
> that seems ugly. Thoughts?

What about a cast?  1::arraytype

Chris



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Roadmap for FE/BE protocol redesign
Next
From: Bruce Momjian
Date:
Subject: Re: Roadmap for FE/BE protocol redesign