Re: Associative array in Pl/PgSQL - Mailing list pgsql-general

From John R Pierce
Subject Re: Associative array in Pl/PgSQL
Date
Msg-id 51859EE1.9030106@hogranch.com
Whole thread Raw
In response to Associative array in Pl/PgSQL  (Karel Riveron Escobar <kescobar@estudiantes.uci.cu>)
Responses Re: Associative array in Pl/PgSQL
List pgsql-general
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

pgsql-general by date:

Previous
From: Karel Riveron Escobar
Date:
Subject: Associative array in Pl/PgSQL
Next
From: Jasen Betts
Date:
Subject: Re: Simple SQL INSERT to avoid duplication failed: why?