Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*select\s+events\s+table\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*select\s+events\s+table\s*$/: 5 ]

Total 5 documents matching your query.

1. select events table (score: 1): Author: goc <goran.k AT VIP DOT HR>; Date: Tue, 7 Nov 2006 09:36:12 +0100; hi, when i make select * from events i get data only for current date , i know with q event you can get back as defined in server options but i would like to make some count(*) and stuff on events da; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-11/msg00105.html (10,708 bytes)
2. Re: select events table (score: 1): Author: Rainer Tammer <tsm AT SPG.SCHULERGROUP DOT COM>; Date: Tue, 7 Nov 2006 10:15:11 +0100; Hello, This is a special table. You need a SELECT similar to the following statement: select count(*) as \"Administrative Schedules Successful\" from events where LENGTH(domain_name) IS NULL and sche; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-11/msg00107.html (11,613 bytes)
3. Re: select events table (score: 1): Author: Matthew Warren <Matthew.Warren AT DIGICA DOT COM>; Date: Tue, 07 Nov 2006 05:37:40 -0500; Odd, how can it be that select * from events returns different to select * from events where scheduled_start>'1900-01-01' How is the table 'special'? Matt. This email is confidential and may be privi; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-11/msg00109.html (13,624 bytes)
4. Re: select events table (score: 1): Author: Henrik Wahlstedt <SHWL AT STATOIL DOT COM>; Date: Tue, 7 Nov 2006 12:01:27 +0100; Nope, see the explanation in 'Why does it Work that Way (Andy Raibeck).pdf' from TSM Symposoium in Oxford 2005. "Events table is calculated at runtime..." etc Cheers Henrik Odd, how can it be that se; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-11/msg00111.html (14,462 bytes)
5. Re: select events table (score: 1): Author: Matthew Warren <Matthew.Warren AT DIGICA DOT COM>; Date: Tue, 07 Nov 2006 09:44:31 -0500; Ahh, I see. I knew that TSM tables were built 'on the fly'; but had't realised that the events table is essentially unbounded, hence the need for the 'special' behaviour. Thanks, Matt.; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-11/msg00113.html (16,210 bytes)

Current List: 1 - 5
Page: [1]