Re: stored function, multiple queries, best practices

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Ash Grove <ash_grv7(at)yahoo(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: stored function, multiple queries, best practices
Date: 2006-04-14 14:18:58
Message-ID: 443FAF52.901@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Ash Grove wrote:

> I currently do this by building a delimited string in
> the application containing all data to be inserted and
> then sending it, via callablestatement, to a stored
> function. The function parses the string, does the
> inserts and returns the primary key via a registered
> out parameter.

Why assemble a string and parse it? Why not just use multiple parameters
directly?

-O

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Ash Grove 2006-04-14 14:37:20 Re: stored function, multiple queries, best practices
Previous Message Ash Grove 2006-04-14 12:48:34 stored function, multiple queries, best practices