Re: Triggers In Informix?

John H. Frantz (frantz@centrum.is) wrote: : >2. Is there anyway that I can cause a SELECT statement to return every : >nth row from the rows satisfying the WHERE clause, where n is a parameter I : >specify at the time of SELECT? Or equally acceptable to return a random : >sample of size n% from the rows satisfying the WHERE clause? : > : Try the following: : SELECT ... FROM ... WHERE ... AND MOD(ROWID,n)=0 Which version of Informix engine does support MOD function? As far as I know, version 5 does not. Mariusz -- ------------------------------------------------------------- Mariusz Ostrowski mariusz@nask.org.pl Research and Academic Computer Networks Warsaw, Poland -------------------------------------------------------------