Re: [sqlite] Re: Collate

2007-11-07 Thread Aviad Harell
n 11/7/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > > Aviad Harell <[EMAIL PROTECTED]> > wrote: > > is there any implications on performance of using collate i(NOCASE for > > example) in the column definition when creating a table? doesn't it > > effect th

[sqlite] Collate

2007-11-07 Thread Aviad Harell
Hi, is there any implications on performance of using collate i(NOCASE for example) in the column definition when creating a table? doesn't it effect the indexes use of those columns? when using collate NOCASE on some column definition, how does a specific element is chose to be returned, the

Re: [sqlite] Re: user defined function

2007-10-10 Thread Aviad Harell
UCT, (SUM(SALES)) AS [SUM_SALES] FROM Test1MX1000Multi AS T1 GROUP BY CUSTOMER, PRODUCT) AS [T1]) AS [TEMP] WHERERANK <= 4 ORDER BY CUSTOMER, RANK On 10/8/07, Igor Tandetnik <[EMAIL PROTECTED]> wrot

[sqlite] user defined function

2007-10-08 Thread Aviad Harell
Hey, I tried to create user defined function called Rank. which gets partition columns and order by column. this function should create rank according to its parameters. i.e.: select customer, product, sales, Rank(customer, sales) from table should return: customerA productA 100 0 customerA

[sqlite] multiple connections

2007-09-02 Thread Aviad Harell
Hi, Regarding only to select statements, is there a known limit of number of concurrent connections to Sqlite DB? What about concurrent connections to the same table in the sqlite DB? Regards, Aviad

[sqlite] Query Help

2007-08-01 Thread Aviad Harell
Hi, I Have a problem with the following query executed on sqlite SELECT CUSTOMER, PRODUCT, [RANK] FROM (SELECT CUSTOMER, PRODUCT, [SUM_SALES], (SELECT COUNT(T2.SUM_SALES) FROM (SELECT CUSTOMER,