Stephen Frost wrote: -- Start of PGP signed section. > * Bruce Momjian ([EMAIL PROTECTED]) wrote: > > Stephen Frost wrote: > > > I'll see about writing up a proper test case/schema. Looks like I'm > > > probably most of the way there at this point, really. ;) > > > > I wasn't aware you could throw binary values into the timestamp fields > > like that. I thought you needed to use a C string for the value. > > > > Does PREPARE bypass that for some reason? > > I don't think so.. As I recall, I think I might have had it set up w/o > using a prepare before and it was working but I'm not sure. It's > certainly very useful and lets me bypass *alot* of overhead > (converting to a string and then making the database convert back...).
Considering all the other things the database is doing, I can't imagine that would be a measurable improvement. > The one complaint I do have is that I don't see a way to pass a > timestamp w/ an explicit timezone in binary format into a table which > has a 'timestamp with timezone' field. I can pass a binary timestamp > into a 'timestamp with timezone' field, but it's interpreted as UTC or > the local timezone (can't remember which atm). I still do not understand how this is working. It must be using our fast path as part of prepare. What language is you client code? -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly