Postgres Pro
Downloads
Home   >   mailing lists

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

From Karel Riveron Escobar
Subject Associative array in Pl/PgSQL
Date
Msg-id 33a4e186-4f34-4b7b-94a3-3aa9eeecb3cf@ucimail4.uci.cu
Whole thread Raw
Responses Re: Associative array in Pl/PgSQL  (John R Pierce <pierce@hogranch.com>)
Re: Associative array in Pl/PgSQL  (Darren Duncan <darren@darrenduncan.net>)
Re: Associative array in Pl/PgSQL  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
Tree view
Hello everyone,

I have a problem with Pl/PgSQL function. I need to pass it as parameter an associative array. I have no idea how to do that. Can somebody help me?

To be more specific, I have an associative array in PHP. Something like this:

array(
     'name' => 'Robert',
     'age' => 24,
     'teachers' => array(
                                   array('name'=>'Sean'),
                                   array('name'=>'Megan')
                            ) 
);

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

Thanks in advance.

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



pgsql-general by date:

Previous
From: mark_r
Date:
Subject: Re: Simple, free PG GUI/query tool wanted
Next
From: John R Pierce
Date:
Subject: Re: Associative array in Pl/PgSQL