Обсуждение: 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@soziologie.rwth-aachen.de>
>To: pgsql-general@postgreSQL.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

Hi.

Thanks for your response.


omid omoomi schrieb:
>
> hi,put it in quotes:
> delete from aktuelles where index='9';
> better not using some predefined key words like "index" as field names.
> >=>delete from aktuelles where index=9;
> >
> >which results in:
> >
> >ERROR:  RestrictionClauseSelectivity: bad value 2.280761

i renamed the coloumn to "idx", but the error still remains... :(

Is there no dictionary of ERRORS (probably with some hints?)

Thanks!

Regards, Ingo.