From: | "Luis Silva" <lfs12(at)hotmail(dot)com> |
---|---|
To: | akretschmer(at)spamfence(dot)net, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: working with arrays inside a plpgsql function |
Date: | 2007-02-15 17:16:55 |
Message-ID: | BAY117-F84773569BC59895989638B5960@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Tks for the answer, I used a different approach based on the information
that you supplied:
Used the function array_to_string and passed the info to a text variable.
BTW, is it possible to pass into an array the result of a query? tks again,
the last answer was very useful!
>From: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
>To: pgsql-novice(at)postgresql(dot)org
>Subject: Re: [NOVICE] working with arrays inside a plpgsql function
>Date: Thu, 15 Feb 2007 17:06:56 +0100
>
>Luis Silva <lfs12(at)hotmail(dot)com> schrieb:
>
> > Hi all!
> >
> > I'm trying to use array inside a pl/pgsql function and I'm having some
> > problems using the all array at the same time. Let me give you an
>example:
> >
> > ident text[];
> >
> > BEGIN
> >
> > ident = $1; -- $1 is a array argument from the plpgsql function
> > EXECUTE 'SELECT count(identity) FROM public_data WHERE identity IN
>||ident
> > INTO asds;
>
>At least a missing ' between IN and ||.
>
>
> > PS - How can I retrieved the size ofthe array? I saw the manual and I
> > couldn't find it.
>
>array_dims(), array_lower(), array_upper()
>http://www.postgresql.org/docs/8.1/interactive/functions-array.html
>
>
>Andreas
>--
>Really, I'm not out to destroy Microsoft. That will just be a completely
>unintentional side effect. (Linus Torvalds)
>"If I was god, I would recompile penguin with --enable-fly." (unknow)
>Kaufbach, Saxony, Germany, Europe. N 51.05082, E 13.56889
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: Don't 'kill -9' the postmaster
_________________________________________________________________
Valentines Day -- Shop for gifts that spell L-O-V-E at MSN Shopping
http://shopping.msn.com/content/shp/?ctId=8323,ptnrid=37,ptnrdata=24095&tcode=wlmtagline
From | Date | Subject | |
---|---|---|---|
Next Message | Gustavo | 2007-02-16 15:45:26 | Doubt about performance of my db design |
Previous Message | Andreas Kretschmer | 2007-02-15 16:06:56 | Re: working with arrays inside a plpgsql function |