Re: Associative array in Pl/PgSQL

Karel Riveron Escobar <kescobar@xxxxxxxxxxxxxxxxxx> · Sat, 04 May 2013 20:02:40 -0400 (EDT)

John:
Thanks for reply so fast. I think that store my data as tables will be the best.

Thanks again.

Regards, Karel RiverónStudent Scientific Council
Informatics Science University

From: "John R Pierce" <pierce@xxxxxxxxxxxx>
To: pgsql-general@xxxxxxxxxxxxxx
Sent: Saturday, May 4, 2013 7:50:57 PM
Subject: Re:  Associative array in Pl/PgSQL

    On 5/4/2013 4:40 PM, Karel Riveron
      Escobar wrote:

    And, I need work with
        it into a Pl/PgSQL function. How can I do this?

    SQL has no such concept as 'associative arrays'.  it understands
    relations (tables).

    maybe convert it to hstore format, and pass it in as a text string,
    but your example gets even messier in that you've nested these
    associative things. 

    would be much more appropriate to store that data as tables in
    postgresql.

    --
john r pierce                                      37N 122W
somewhere on the middle of the left coast