pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Patricia Rodriguez-Tome <tome@ebi.ac.uk>
To: pgsql-sql@postgresql.org
Subject: Problem with simple select, RestrictionClauseSelectivity ERROR
Date: Wed, 13 Jan 1999 17:34:41 GMT
Message-ID: <199901131734.RAA02518@sol6.ebi.ac.uk> (raw)



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
========================================================================





view thread (4+ messages)  latest in thread

Message-ID: <199901131734.RAA02518@sol6.ebi.ac.uk>
Permalink:  ../199901131734.RAA02518@sol6.ebi.ac.uk/
Also on:    postgresql.org/message-id/199901131734.RAA02518@sol6.ebi.ac.uk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: tome@ebi.ac.uk
  Subject: Re: Problem with simple select, RestrictionClauseSelectivity ERROR
  In-Reply-To: <199901131734.RAA02518@sol6.ebi.ac.uk>
  References: <199901131734.RAA02518@sol6.ebi.ac.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox