Re: [GENERAL] Passing row set into PL/pgSQL function.

2012-09-20 Thread Craig Ringer
On 09/20/2012 01:47 PM, Lucas Clemente Vella wrote: http://www.depesz.com/2012/06/10/why-is-upsert-so-complicated/ I have already seen this page, I am OK in running SERIALIZABLE transactions, and have no problem in replaying failed transactions due to race condition. Anyway, that is completely

Re: [GENERAL] Passing row set into PL/pgSQL function.

2012-09-20 Thread Merlin Moncure
On Wed, Sep 19, 2012 at 4:37 PM, Lucas Clemente Vella lve...@gmail.com wrote: I am trying to write a generic upsert function in PL/pgSQL, in a way that I can specify the table were I want to insert/update, the columns whose values I want to specify, and the values to be inserted. So far I

Re: [GENERAL] Passing row set into PL/pgSQL function.

2012-09-20 Thread Lucas Clemente Vella
http://www.depesz.com/2012/06/10/why-is-upsert-so-complicated/ I have already seen this page, I am OK in running SERIALIZABLE transactions, and have no problem in replaying failed transactions due to race condition. Anyway, that is completely off my issue: I need upsert and I am prepared to deal

[GENERAL] Passing row set into PL/pgSQL function.

2012-09-19 Thread Lucas Clemente Vella
I am trying to write a generic upsert function in PL/pgSQL, in a way that I can specify the table were I want to insert/update, the columns whose values I want to specify, and the values to be inserted. So far I have come up with a solution whose signature is: CREATE OR REPLACE FUNCTION

Re: [GENERAL] Passing row set into PL/pgSQL function.

2012-09-19 Thread Craig Ringer
On 09/20/2012 05:37 AM, Lucas Clemente Vella wrote: I am trying to write a generic upsert function in PL/pgSQL, in a way that I can specify the table were I want to insert/update, the columns whose values I want to specify, and the values to be inserted.