[SQL] SQLMAP IBATIS insert values from web forms to a money type column

2006-08-14 Thread Emi Lu
Hello, I am using SQLMAP ibatis to do DB insertion for a webapplication. In my sqlmap.xml file, I was trying to insert values into a table with one col (type is Money), but in java, I could not find Money type. Does someone knows about ibatis how to make values got from the web form to be in

Re: [SQL] SQLMAP IBATIS insert values from web forms to a money type column

2006-08-14 Thread Andrew Sullivan
The money type is deprecated. Use numeric with two places. A On Mon, Aug 14, 2006 at 09:49:29AM -0400, Emi Lu wrote: > Hello, > > I am using SQLMAP ibatis to do DB insertion for a webapplication. > > In my sqlmap.xml file, I was trying to insert values into a table with > one col (type is Mon

[SQL] Multiple DB join

2006-08-14 Thread Sumeet Ambre
Hi All, I have a database which consists of 20 million records and I've split up the db into 6-7 dbs. I have a base database which consists of the ids with link all the databases. I'm performing search on this single base table. After searching i get some ids which are ids in the other database

Re: [SQL] Multiple DB join

2006-08-14 Thread Shoaib Mir
I think using the contrib module 'dblink' (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dblink/) can help you here.Thanks, -- Shoaib MirEnterpriseDB (www.enterprisedb.com)On 8/15/06, Sumeet Ambre < [EMAIL PROTECTED]> wrote:Hi All,I have a database which consists of 20 million records an

Re: [SQL] Using bitmap index scans-more efficient

2006-08-14 Thread Kyle Bateman
Florian Weimer wrote: * Kyle Bateman: Any ideas about whether/how this can be done? If the project tree is fairly consistent, it's convenient to encode it using intervals instead of parent/child intervals. IIRC, Celko's "SQL for smarties" explains how to do this, and Kristian Koehnt

Re: [SQL] Using bitmap index scans-more efficient

2006-08-14 Thread Tom Lane
Kyle Bateman <[EMAIL PROTECTED]> writes: > But I'm assuming that using an interval-encoded project tree, I would > have to do something like the following to get a progency group: > select * from ledger l, proj p where p.proj_id = l.proj and p.left > > 1234 and p.right < 2345; btree has no idea