Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2010
    Posts
    1

    Unanswered: Error with tsquery tsvector

    Hi,

    I received and error while working with Full Text search in postgresql 8.4.1
    The syntax as follows:
    1) SELECT * from mytable where vector @@ to_tsquery('boll:*');
    gives result --->
    vector | id
    -------------------------------------------------------------------+----
    'bollywood':1 'challeng':6 'new':5 'particip':8 'quiz':2 'test':7 | 2

    2) when I search for bollyw
    SELECT * from mytable where vector @@ to_tsquery('bollyw:*');
    gives result --->
    vector | id
    -------------------------------------------------------------------+----
    'bollywood':1 'challeng':6 'new':5 'particip':8 'quiz':2 'test':7 | 2

    But when I search for bolly:

    SELECT * from mytable where vector @@ to_tsquery('bolly:*');

    It gives no results.


    I could not get why this is happening

    Thank You very Much in advance.
    Last edited by Kirtikumar; 04-23-10 at 08:00.

  2. #2
    Join Date
    Apr 2010
    Posts
    2

    Need details

    would it possible to post the schema of mytable along with sample records?

  3. #3
    Join Date
    Apr 2010
    Posts
    2

    links to docs

    not sure if the docs would help you out:

    Controlling Text Search

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •