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
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
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
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
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
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
