[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

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 Money),

[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

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 and

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

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 about