Re: stored function, multiple queries, best practices

Поиск
Список
Период
Сортировка
От Ash Grove
Тема Re: stored function, multiple queries, best practices
Дата
Msg-id 20060414143720.5342.qmail@web52512.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: stored function, multiple queries, best practices  (Oliver Jowett <oliver@opencloud.com>)
Ответы Re: stored function, multiple queries, best practices  (Oliver Jowett <oliver@opencloud.com>)
Список pgsql-jdbc

>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')"?

> 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


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Oliver Jowett
Дата:
Сообщение: Re: stored function, multiple queries, best practices
Следующее
От: Jeff Hubbach
Дата:
Сообщение: Re: Possible regression: setNull() usage changed from 7.4 to