Dave Cramer <[EMAIL PROTECTED]> writes:
> I was thinking that it may be necessary to issue a describe before
> the execute, but I'm thinking now that the driver can only handle
> specific types, so anything outside of what it knows about would be
> an error anyway.
> I gather it's not possib
Yeah,
I finally read it through and found it. There's some anecdotal
evidence of up to 2x performance, so I'm interested in how to
implement this in the jdbc driver. ( I'm a little skeptical about 2x)
I was thinking that it may be necessary to issue a describe before
the execute, but I'm
Dave Cramer <[EMAIL PROTECTED]> writes:
> Is there a way to force select * from foo to use binary values ?
In what context?
There is a provision for that in the V3 extended-query protocol.
regards, tom lane
---(end of broadcast)---
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> The MySQL syntax is actually "drop table if exists foo ...".
> Implementing this unfortunately generates a shift/reduce conflict,
What did you try exactly? I don't see any fundamental reason for
a conflict here. You may just need to rearrange the gr
On Sun, Nov 13, 2005 at 11:32:47PM +0100, Petr Jelinek wrote:
> I am really not db expert and I don't have copy of sql standard but you
> don't need to use 2 tables I think - USING part can also be subquery
> (some SELECT) and if I am right then you could simulate what REPLACE
> does because in
Peter Eisentraut wrote:
In that regard, MERGE is quite flexible, but MERGE doesn't address the
point of REPLACE, because MERGE requires *two* tables as input, whereas
REPLACE only takes *one*. Unless someone can show that you can trick
MERGE into doing the REPLACE job anyway, we're not discu
Martijn van Oosterhout wrote:
> None of this applies to PostgreSQL because we open the modules
> directly, and don't rely on the linker loader.
Ah, right. I forgot the context was the server, not one of the
utilities...
Sorry for the waste of bandwidth...
--
Kevin Brown
Is there a way to force select * from foo to use binary values ?
Dave
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
I wrote:
> ... Now, when the bitmap is present, it would be fairly tedious
> to calculate the length of the bitmap to determine the offset to the
> actual data; and that's an operation that we'd like to be cheap. What
> I'm thinking of doing is commandeering the whole "flags" field of
> ArrayType
Tom Lane wrote:
> IIRC, SQL's MERGE deals with this by offering two quite separate
> specifications of what to do when there is or isn't already a
> matching row.
In that regard, MERGE is quite flexible, but MERGE doesn't address the
point of REPLACE, because MERGE requires *two* tables as input,
I wrote:
> Martijn van Oosterhout writes:
>> In this particular case the syntax makes it unclear that the substring
>> is the problem. Perhaps here the solution would be to put a cast in the
>> grammer, like so:
> ...
> But I think we could do this in substr_list in the case where we have
> just "
On Sun, 13 Nov 2005, Joost Kraaijeveld wrote:
You have tested this with an insert statement. Could you do that also
for an update (or try to tell me how I can do that)? I am getting very
strange differences in running time between inserts and update ( 26
inserts are measured in seconds,
Petr Jelinek wrote:
Tom Lane wrote:
It'd be useful to look at what comparable functionality is offered by
other DBs besides MySQL. Anyone know what DB2 or Oracle have in this
area?
Oracle:
http://www.psoug.org/reference/merge.html
http://www.psoug.org/reference/translate_replace.html
But
Tom Lane wrote:
It'd be useful to look at what comparable functionality is offered by
other DBs besides MySQL. Anyone know what DB2 or Oracle have in this
area?
IIRC they both have MERGE.
--
Regards
Petr Jelinek (PJMODOS)
---(end of broadcast)--
I was just looking briefly at doing "drop if exists" as we discussed
recently.
The MySQL syntax is actually "drop table if exists foo ...".
Implementing this unfortunately generates a shift/reduce conflict,
unless I put IF in the func_name_keyword list, which strikes me as a bad
idea.
Alt
Robert Treat <[EMAIL PROTECTED]> writes:
> I disagree in that REPLACE is advertised as a solution for the INSERT else
> UPDATE problem, but has a different behavior than a true INSERT else UPDATE
> would produce. Maybe that's a problem with the implementation, or maybe
> it's a problem in the
On Sunday 13 November 2005 10:01, Gregory Maxwell wrote:
> On 11/13/05, Robert Treat <[EMAIL PROTECTED]> wrote:
> > On Saturday 12 November 2005 04:06, Matteo Beccati wrote:
> > > | 1 |1 | NULL |
> >
> > Wow, that seems ugly maybe there's a reason for it, but I'm not sure
> > we could devia
On Sun, 13 Nov 2005, Joost Kraaijeveld wrote:
I have a connection that is created with "prepareThreshold=1" in the
connection string. I use a prepared statement that I fill with
addbatch() and that I execute with executeBatch() (for full source: see
"application.java" attachment).
LOG: stateme
On 11/12/05, Matteo Beccati <[EMAIL PROTECTED]> wrote:
> Tom Lane wrote:
> > Peter Eisentraut <[EMAIL PROTECTED]> writes:
> >> It seems to me that it has always been implicitly assumed around here
> >> that the MERGE command would be a substitute for a MySQL-like REPLACE
> >> functionality. After
Joe Conway <[EMAIL PROTECTED]> writes:
> Jim C. Nasby wrote:
>> Instead of bending over backwards to try and support older cases, would
>> a compatability mode be possible? Seems that would solve a lot of
>> problems.
> Last time I thought about this problem, that's what I concluded. I don't
> th
Tom Lane wrote:
Matt Newell <[EMAIL PROTECTED]> writes:
BTW, i'm on the list now, so no need to cc me.
Common practice around here is to cc people anyway --- this has grown
out of a history of occasionally-slow list mail delivery. If you don't
want it, best to fix it in your mail f
Oliver Jowett <[EMAIL PROTECTED]> writes:
> The driver does not actually issue PREPARE or EXECUTE statements; the
> server is pretending that the protocol-level Prepare/Bind/Execute
> messages are actually something issuing PREPARE/EXECUTE at the SQL level
I had not realized that the logging co
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> Maybe the solution is to make inherited tables actually the same table,
> and jank it with an extra per-row attribute to differentiate them or
> something :)
Aside from destroying the inheritance-for-partitioning stuff, this
wouldn't work for
On Sat, Nov 12, 2005 at 10:46:33PM -0800, Kevin Brown wrote:
> Hmm...but isn't the version number also something that can be stored
> in the shared library itself during link time (e.g., via the -soname
> option to the linker)? The manpage for ld under Linux implies that
> this will cause the exec
On 11/13/05, Robert Treat <[EMAIL PROTECTED]> wrote:
> On Saturday 12 November 2005 04:06, Matteo Beccati wrote:
> > | 1 |1 | NULL |
> Wow, that seems ugly maybe there's a reason for it, but I'm not sure we
> could deviate from my$ql's behavior on this even if we wanted... they are the
> "s
On Saturday 12 November 2005 04:06, Matteo Beccati wrote:
> Tom Lane wrote:
> > Peter Eisentraut <[EMAIL PROTECTED]> writes:
> >> It seems to me that it has always been implicitly assumed around here
> >> that the MERGE command would be a substitute for a MySQL-like REPLACE
> >> functionality. Aft
Hi Kris,
You have tested this with an insert statement. Could you do that also for an
update (or try to tell me how I can do that)? I am getting very strange
differences in running time between inserts and update ( 26 inserts are
measured in seconds, 26 updates over 1 column in the same
On Sun, 13 Nov 2005, Joost Kraaijeveld wrote:
I have a connection that is created with "prepareThreshold=1" in the
connection string. I use a prepared statement that I fill with
addbatch() and that I execute with executeBatch() (for full source: see
"application.java" attachment).
LOG: state
28 matches
Mail list logo
