Skip site navigation (1) Skip section navigation (2)

RestrictionClauseSelectivity

From: Ingo Assenmacher <Ingo(dot)Assenmacher(at)soziologie(dot)rwth-aachen(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: RestrictionClauseSelectivity
Date: 2000-02-23 11:41:50
Message-ID: 38B3C77E.F364329D@soziologie.rwth-aachen.de (view raw or flat)
Thread:
Lists: pgsql-general
Hi All!

I have the following table:

Name: recent

+----------------------------------+----------------------------------+-------+
|              Field               |              Type                |
Length|
+----------------------------------+----------------------------------+-------+
| datum                            | date not null                   
|     4 |
| aktuell_text                     | text not null                   
|   var |
| erzeuger                         | char()                          
|     5 |
| index                            | int2                            
|     2 |
+----------------------------------+----------------------------------+-------+  

Filled with some data (about 9 rows).

I want to delete a specific row with:

=>delete from aktuelles where index=9;

which results in:

ERROR:  RestrictionClauseSelectivity: bad value 2.280761

Where can I find help on this?

I am using PostgreSQL V6.4 on a Linux/i386 2.2.10 System.

Thanks for your help!

Regards, Ingo.

pgsql-general by date

Next:From: Ingo AssenmacherDate: 2000-02-23 11:50:34
Subject: RestrictionClauseSelectivity
Previous:From: Wim CeulemansDate: 2000-02-23 11:09:14
Subject: Re: [GENERAL] AW: [HACKERS] TRANSACTIONS

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group