Re: [GENERAL] Associative array in Pl/PgSQL

2013-05-06 Thread Merlin Moncure
On Sat, May 4, 2013 at 6:40 PM, Karel Riveron Escobar wrote: > > 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. Som

Re: [GENERAL] Associative array in Pl/PgSQL

2013-05-04 Thread Darren Duncan
On 2013.05.04 4:40 PM, Karel Riveron Escobar wrote: 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: a

Re: [GENERAL] Associative array in Pl/PgSQL

2013-05-04 Thread Jasen Betts
On 2013-05-04, Karel Riveron Escobar wrote: > --=_be60f7f0-365e-4e0a-98b5-f8b13a8ea728 > Content-Type: text/plain; charset=utf-8 > Content-Transfer-Encoding: quoted-printable > > Hello everyone, > > > I have a problem with Pl/PgSQL function. I need to pass it as parameter an = > associative array

Re: [GENERAL] Associative array in Pl/PgSQL

2013-05-04 Thread Karel Riveron Escobar
day, 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

Re: [GENERAL] Associative array in Pl/PgSQL

2013-05-04 Thread John R Pierce
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 g