Re: Associative array in Pl/PgSQL

John:

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

Thanks again.

Regards, Karel Riverón
Student Scientific Council
Informatics Science University
----- Original Message -----

| From: "John R Pierce" <pierce(at)hogranch(dot)com>
| To: pgsql-general(at)postgresql(dot)org
| Sent: Saturday, May 4, 2013 7:50:57 PM
| Subject: Re: [GENERAL] 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

http://www.uci.cu