Here's an example I just thought of that would be great to document: I have an array of integers. I'd like to also associate some names with them. I can't do this in the same array, but I can do it in a different array. But how do I ensure that when I build that array using name=ARRAY(SELECT name FROM table WHERE id = ANY(id_array) ) that name[1] actually corresponds to id_array[1]?
On Tue, Nov 02, 2004 at 02:43:42PM -0600, Jim C. Nasby wrote: > The datatypes chapter mentions nothing about ARRAY(), for starters. I'm > not suggesting that the reference is incomplete, but I think a chapter > explaining some about arrays, how to use them, and what you can do with > them would be useful. > > On Mon, Nov 01, 2004 at 11:11:31PM +0100, Peter Eisentraut wrote: > > David Fetter wrote: > > > Anyhow, where do you think it should go? > > > > In the chapter on data types -- where it already is. > > > > -- > > Peter Eisentraut > > http://developer.postgresql.org/~petere/ > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > > > > -- > Jim C. Nasby, Database Consultant [EMAIL PROTECTED] > Give your computer some brain candy! www.distributed.net Team #1828 > > Windows: "Where do you want to go today?" > Linux: "Where do you want to go tomorrow?" > FreeBSD: "Are you guys coming, or what?" > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?" ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
