[GENERAL] RestrictionClauseSelectivity

2000-02-23 Thread Ingo Assenmacher 

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.

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

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.