Re: select events table

2006-11-07 Thread Matthew Warren
OTECTED] > On Behalf Of Henrik Wahlstedt > Sent: 07 November 2006 11:01 > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] select events table > > Nope, see the explanation in 'Why does it Work that Way (Andy > Raibeck).pdf' from TSM Symposoium in Oxford 2005. &g

Re: select events table

2006-11-07 Thread Henrik Wahlstedt
hew Warren Sent: den 7 november 2006 11:37 To: ADSM-L@VM.MARIST.EDU Subject: Re: select events table 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. >

Re: select events table

2006-11-07 Thread Matthew Warren
ainer Tammer > Sent: 07 November 2006 09:15 > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] select events table > > Hello, > > goc wrote: > > hi, > > when i make select * from events i get data only for current date , > > i know with q event you can get ba

Re: select events table

2006-11-07 Thread Rainer Tammer
Hello, goc wrote: > 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 data, > so my question is can i get further in past with direct select stat

select events table

2006-11-07 Thread goc
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 data, so my question is can i get further in past with direct select statement to events table ? tha