Problem understanding this query output

[geroid]

Hi
I have a table called docs with 2 columns 'id' and 'text' and have inserted the following information

INSERT INTO docs VALUES (1, ‘Oracle stuff’);
INSERT INTO docs VALUES (2, ‘more Oracle stuff’);
INSERT INTO docs VALUES (3, ‘SQL Server stuff’);
COMMIT;

I then run the following query as part of a college lab. I can't understand the output or what this query is asking. Can you help? The query is:

SELECT SCORE(1) FROM docs WHERE CONTAINS (text, ‘Oracle’, 1) > 0;

The output is:

SCORE(1)
-----------
          4
          4

I don't understand what the two 4s refer to. Can anyone explain

 

[r937]

the two 4s are the SCORE(1) values of the rows that satisfy the WHERE clause

which would make sense if there were a SCORE function, but there isn't

would you mind showing us your real query, not this oversimplification?

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon