On 6 April 2011 11:51, tejas tank <tejas.tank.mca@xxxxxxxxx> wrote: > 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.????? We'd need to see the query, but I suspect you're evaluating a scalar against a subquery expression, and it's the 670th record which returns more than 1 record in the subquery. -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935 EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
