Transitivité de la fonction Contains [Résolu]

[ramroum1986]

Bonjour,

Je voulais savoir si :

Code :

Contains (colonne, A OR B AND C) > 0

est identique à :

Code :

1
2
3
    Contains (colonne, A) > 0
 OR Contains (colonne, B) > 0
AND Contains (colonne, C) > 0

Merci pour toute aide.

[pacmann]

Salut,

Je dirais oui.
http://docs.oracle.com/cd/A57673_01/.../ch03.htm#1360

AND Operator

Use the AND operator to search for documents that contain at least one occurrence of each of the query terms. For example, to obtain all the documents that contain the terms batman and robin and penguin, issue the following query:

'batman & robin & penguin'

In an AND query, the score returned is the score of the lowest query term. In the example above, if the three individual scores for the terms batman, robin, and penguin is 10, 20 and 30 within a document, the document scores 10.
OR Operator

Use the OR operator to search for documents that contain at least one occurrence of any of the query terms. For example, to obtain the documents that contain the term cats or the term dogs, use one of the following:

'cats | dogs'
'cats OR dogs'

In an OR query, the score returned is the score for the highest query term. In the example above, if the scores for cats and dogs is 30 and 40 within a document, the document scores 40.

(Le plus petit des scores est positif <=> les deux sont positifs
Le plus grand des deux scores est positif <=> au moins l'un des deux scores est positif)

[ramroum1986]

Merci Beaucoup

[Rei Ichido]

Attention, différencier les contains force à différencier le comptage ! Si la valeur SCORE n'est pas utilisée, c'est effectivement équivalent, mais il faut quand même faire attention.

Avec l'exemple du OR cité ci-dessus :

Code :

1
2
3
4
 
SELECT SCORE(1)
  FROM ...
 WHERE CONTAINS(colonne,'cats | dogs',1) > 0

=> Retourne 40

MAIS

Code :

1
2
3
4
5
 
SELECT SCORE(1)
  FROM ...
 WHERE CONTAINS(colonne,'cats',1) > 0
    AND CONTAINS(colonne,'dogs',2) > 0

=> Retourne 30