been suggested that ROWNUM could be replaced
by the nextval of a temporary sequence.
Kris Jurka
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
ch09s05.html
Soon to be committed cvs version: can directly use server prepared
statements without using the SQL level PREPARE/EXECUTE.
Kris Jurka
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-
ample because this
functionality is undocumented in the released version. In the 7.4 version
the enabling of server side statements is only possible via a boolean flag
at the statement level, namely PGStatement.setUseServerPrepare(true);
Kris Jurka
---(end of broadca
7;t know why this would be different for you. What exact version of
the server and driver are you using?
Kris Jurka
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
not one of unknown type.
Ideally you should be using setArray, but there is no existing way to
create Array objects and I'm not sure that code would work even if there
was.
Kris Jurka
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
at with a callable statement
it is examinging the query with "call" before it is transformed to a
SELECT, so it doesn't recognize it as a preparable. This looks like a bug
to me.
Kris Jurka
---(end of broadcast)---
TIP 3: if po
gh it doesn't use a server prepared
statement, and as I mentioned earlier the performance improvement if any
will be minimal. Have you done any testing to show that you are even
getting a performance gain?
Kris Jurka
---(end of broadcast)--
be found, but remember the
premature optimization adage.
>
> Secondly, I assume the function should be a pre-compiled object stored
> on server side, doesn't it.
>
I depends on the language the function is written. plpgsql caches plans,
but not all procedural
a known issue. It's on the list.
Kris Jurka
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
ATER VIEW v AS SELECT (a+b)::numeric(6,2) FROM tab;
Kris Jurka
---(end of broadcast)---
TIP 8: explain analyze is your friend
eveal anything you
might try upgrading the JDBC driver to a later version.
Kris Jurka
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
a recent off-topic question from
him which I responded to with an answer and a suggestion of the
appropriate list. As long as answers keep coming the hint will not be
picked up.
Kris Jurka
---(end of broadcast)---
TIP 2: you can get off all lis
12 matches
Mail list logo
