Hello, I have hug postgresql database and when i going to search for a query with database retrieve with limit of 669 is allow If my query fetch records more over 669 records then error is comming... RROR: more than one row returned by a subquery used as an _expression_ ********** Error ********** ERROR: more than one row returned by a subquery used as an _expression_ SQL state: 21000 What should I have to do.????? Its urgent .... Thanks, Tejas L Tank. Ass. Application Engineer. OpenERP Pvt. Ltd. India