Re: stored function, multiple queries, best practices - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: stored function, multiple queries, best practices
Date
Msg-id 444198D6.4080805@opencloud.com
Whole thread Raw
In response to Re: stored function, multiple queries, best practices  (Ash Grove <ash_grv7@yahoo.com>)
Responses Re: stored function, multiple queries, best practices
List pgsql-jdbc
Ash Grove wrote:
>
>>Why assemble a string and parse it? Why not just use
>>multiple parameters
>>directly?
>>-O
>
>
>
> So, Oliver,  you're suggesting something like "call
> myfunction('query1','query2','query3')"?

No, I'm suggesting:

   call myfunction('data value 1', 42, 1.234, 'data value 4')

I am assuming you know the combinations of updates you will need to run
ahead of time. If you want to run arbitary queries then you are probably
stuck with doing some parsing in the function .. but that is pretty nasty.

-O

pgsql-jdbc by date:

Previous
From: "Clemens A Mensik"
Date:
Subject: test-mail
Next
From: David Goodenough
Date:
Subject: Re: What is the number equivalient of LIMIT ALL