Received: from alpha1.ebi.ac.uk (root@alpha1.ebi.ac.uk [193.62.196.122]) by hub.org (8.9.1/8.9.1) with ESMTP id MAA03594 for ; Wed, 13 Jan 1999 12:34:47 -0500 (EST) (envelope-from tome@sol2.ebi.ac.uk) Received: from sol2.ebi.ac.uk (sol2.ebi.ac.uk [193.62.196.5]) by alpha1.ebi.ac.uk (8.8.7/8.8.7) with ESMTP id RAA06400 for ; Wed, 13 Jan 1999 17:34:42 GMT Received: from sol6.ebi.ac.uk (sol6.ebi.ac.uk [193.62.196.160]) by sol2.ebi.ac.uk (8.8.6/8.8.7) with ESMTP id RAA29548 for ; Wed, 13 Jan 1999 17:34:42 GMT From: Patricia Rodriguez-Tome Received: (from tome@localhost) by sol6.ebi.ac.uk (8.8.6/8.8.6) id RAA02518 for pgsql-sql@postgresql.org; Wed, 13 Jan 1999 17:34:41 GMT Date: Wed, 13 Jan 1999 17:34:41 GMT Message-Id: <199901131734.RAA02518@sol6.ebi.ac.uk> Subject: Problem with simple select, RestrictionClauseSelectivity ERROR To: pgsql-sql@postgresql.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-MD5: D86QszC8pNGXXcjE+tHrWQ== Hello, I have a very simple select , and get an error back I do not understand : rhalloc=> select id from groupe where species='mouse'; ERROR: RestrictionClauseSelectivity: bad value -170141183460469231731687303715884105728.000000 I can select on all the other fields. The field species was added after the creation of the table, and the data in that field added at that time. What have I done wrong? thanks for any pointers, here is all my table def (and data since there are only 3 rows !) The table is very small : rhalloc=> select * from groupe; id|contact_id| sub_date|size|release_date|status |species --+----------+----------+----+------------+-------+------- 1| 31|23-04-1998| 474| |pending|mouse 2| 36|03-08-1998|3496| |pending|mouse 3| 3|28-05-1998| 799| |pending|mouse (3 rows) and here is the format : rhalloc=> \d groupe Table = groupe +----------------------------------+----------------------------------+-------+ | Field | Type | Length| +----------------------------------+----------------------------------+-------+ | id | int4 not null | 4 | | contact_id | int4 not null | 4 | | sub_date | date not null | 4 | | size | int4 not null | 4 | | release_date | date | 4 | | status | text not null | var | | species | text | var | +----------------------------------+----------------------------------+-------+ cheers pat ======================================================================= Dr. Patricia Rodriguez-Tome | URL: http://www.ebi.ac.uk R & D Coordinator The EMBL Outstation, Hinxton - The European Bioinformatics Institute Wellcome Trust genome Campus, Hinxton | Tel: +44 (0)1223 494 409 Cambridge CB10 1SD, UK | Fax: +44 (0)1223 494 468 ========================================================================