Re: [GENERAL] RestrictionClauseSelectivity

hi,put it in quotes:
delete from aktuelles where index='9';
better not using some predefined key words like "index" as field names.

>From: Ingo Assenmacher <ingo(at)soziologie(dot)rwth-aachen(dot)de>
>To: pgsql-general(at)postgreSQL(dot)org
>Subject: [GENERAL] RestrictionClauseSelectivity
>Date: Wed, 23 Feb 2000 12:55:43 +0100
>
>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.
>
>************
>

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com