pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres Array Traversing Problem
2+ messages / 2 participants
[nested] [flat]
* Postgres Array Traversing Problem
@ 2007-10-04 09:26 yogesh <yogesh.arora.daffodil@gmail.com>
2007-10-05 08:55 ` Re: Postgres Array Traversing Problem Dawid Kuroczko <qnex42@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: yogesh @ 2007-10-04 09:26 UTC (permalink / raw)
To: pgsql-admin@postgresql.org
Hello Friends,
I have a Problem in Accessing Arrays in the Postgres.
The Description of my problem is given
here:-----------------------
I have two array of numeric types. One That stores the IDs and Other
Store their values at respective position.
One Id could be in more than one Row's Array. Now i have to search
the ID if it is present in the Array or not.
If present then at what position and to retrieve the corresponding
ID and its Value....present in the other table......
Is there any solution of it................If any Body knows please
reply me as soon as possible.......
any kind of help is appreciated
If you have any problem in understanding problem then mail me....
My EMail Ids are yogesh.arora.daffodil@gmail.com and
yogesh.arora@daffodildb.com
I am in wait of your responses............
Thanks in advance..............
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Postgres Array Traversing Problem
2007-10-04 09:26 Postgres Array Traversing Problem yogesh <yogesh.arora.daffodil@gmail.com>
@ 2007-10-05 08:55 ` Dawid Kuroczko <qnex42@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Dawid Kuroczko @ 2007-10-05 08:55 UTC (permalink / raw)
To: yogesh <yogesh.arora.daffodil@gmail.com>; +Cc: pgsql-sql
On 10/4/07, yogesh <yogesh.arora.daffodil@gmail.com> wrote:
> Hello Friends,
>
> I have a Problem in Accessing Arrays in the Postgres.
> The Description of my problem is given
> here:-----------------------
> I have two array of numeric types. One That stores the IDs and Other
> Store their values at respective position.
> One Id could be in more than one Row's Array. Now i have to search
> the ID if it is present in the Array or not.
Any specific reason why you use arrays instead of normalizing your
schema?
> If present then at what position and to retrieve the corresponding
> ID and its Value....present in the other table......
> Is there any solution of it................If any Body knows please
> reply me as soon as possible.......
You should use pgsql-sql@postgresql.org list for this type
of questions.
The safest route would be to use PL/pgSQL procedure which
iterates the array elements. It should be quite simple.
Play with this.
Regards,
Dawid
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-10-05 08:55 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-10-04 09:26 Postgres Array Traversing Problem yogesh <yogesh.arora.daffodil@gmail.com>
2007-10-05 08:55 ` Dawid Kuroczko <qnex42@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox