Re: [GENERAL] RestrictionClauseSelectivity

2000-02-23 Thread Ingo Assenmacher

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.





Re: [GENERAL] RestrictionClauseSelectivity

2000-02-23 Thread omid omoomi

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 <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>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