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
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" | To: pgsql-general@postgresql.org | Sent: Saturday, May 4,

Re: [GENERAL] Simple SQL INSERT to avoid duplication failed: why?

2013-05-04 Thread Jasen Betts
On 2013-05-01, Carlo Stonebanks wrote: > There are no client poolers (unless pgtcl has one I don't know about) so > this is unlikely. > > The trigger is an interesting idea to try if it happens again - I can't keep > it for long as it is for a massive cache (used to deflect calls to a web > servi

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

[GENERAL] Associative array in Pl/PgSQL

2013-05-04 Thread Karel Riveron Escobar
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. C an s omebody help me? To be more specific, I have an associative array in PHP. Something like this: array( 'name' => 'Robert', 'age' => 24, 'teacher