From: | "Jim C(dot) Nasby" <decibel(at)decibel(dot)org> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | David Fetter <david(at)fetter(dot)org>, PostgreSQL Docs <pgsql-docs(at)postgresql(dot)org> |
Subject: | Re: Array function |
Date: | 2004-11-02 23:31:36 |
Message-ID: | 20041102233136.GS55164@decibel.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
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 majordomo(at)postgresql(dot)org
> >
>
> --
> Jim C. Nasby, Database Consultant decibel(at)decibel(dot)org
> 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 decibel(at)decibel(dot)org
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?"
From | Date | Subject | |
---|---|---|---|
Next Message | Dariusz Dzingielewski | 2004-11-04 16:38:02 | multimedia data storage issue |
Previous Message | Jim C. Nasby | 2004-11-02 20:43:42 | Re: Array function |