I'm guessing that you're seeing duplicate results in your output, or some that are completely missing, or a mixture of both?
cheers, Richard 2008/7/11 Olivier Arnaiz <[EMAIL PROTECTED]>: > Hello, > I am using biomart with a postgres database (7.4). > And all seem work perfectly with the count of the results but I can > not obtain a good table with an 'export' or a 'view all results'. > When I see the log4 log, I can remark that the query is split in many sql > using LIMIT and OFFSET... So why not ... > but I do not see an ORDER BY command and this parameter seems to be > necessary to obtain my good results... > SELECT main.name,[dm_table].field FROM main, dm WHERE main.key=dm.key AND > dm.field =t LIMIT 200 > SELECT main.name,[dm_table].field FROM main, dm WHERE main.key=dm.key AND > dm.field =t LIMIT 200 OFFSET 200 > SELECT main.name,[dm_table].field FROM main, dm WHERE main.key=dm.key AND > dm.field =t LIMIT 400 OFFSET 400 > instead of : > SELECT main.name,[dm_table].field FROM main, dm WHERE main.key=dm.key AND > dm.field =t ORDER BY main.key LIMIT 200 > SELECT main.name,[dm_table].field FROM main, dm WHERE main.key=dm.key AND > dm.field =t ORDER BY main.key LIMIT 200 OFFSET 200 > SELECT main.name,[dm_table].field FROM main, dm WHERE main.key=dm.key AND > dm.field =t ORDER BY main.key LIMIT 400 OFFSET 400 > > That is a problem with postgres versus MySQL (I do not have any experience > with MySQL) or a problem with my config ... or something else ? > Any suggestions > Thanks > Olivier > > -- > Olivier Arnaiz > CGM-CNRS > 91198 Gif-sur-Yvette > 01 69 82 43 75 > ParameciumDB: > http://paramecium.cgm.cnrs-gif.fr/ > > > >
