Alfred, Would you mind sharing your original query as well as the modified one (again) with us? --- That's much simpler (for us) than searching backwards through our email archives ... ... also your create table statement(s) might be helpful ... Thanks! Stefan On Thu, Mar 19, 2009 at 08:22:54AM -0700, Alfred Nordman wrote:
Now there's something else, with the updated version:
In the query I wrote before, If I add a cast to row_number() as DOUBLE, then the same query as before doesn't return any results.
If I cast it as INT, I do get results.
Why is that?
Thanks Alfred. -- View this message in context: http://www.nabble.com/Row_Number%28%29-over-problem-tp22577176p22601449.html Sent from the monetdb-users mailing list archive at Nabble.com.
------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |