consulta fix a sql con vectores

From: Javier Barcena <javierbuilder(at)gmail(dot)com>
To: pgsql-es-ayuda(at)postgresql(dot)org
Subject: consulta fix a sql con vectores
Date: 2009-08-04 21:31:27
Message-ID: 86da9c550908041431v20d1cd0bn607dafa1dde08fd0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Buenas taardes lista , en esta consulta, implemento un vector en un OR
.pero al ejecutarla.. cuando busca por SSN osea un numero.. y es laprimera
parte del or. funciona bien .. pero cuando implemento la busqueda por
nombre que es la segunda parte del OR , obtengo resultado vacio. la consulta
no me devuelve nada..

Les consulto por si pueden mirarla. y decirme porque el vector no em esta
devolviendo valores.
GRacias.

SELECT "advisors"."id" AS t0_r0, "advisors"."organization_id" AS t0_r1,
"advisors"."code_name" AS t0_r2, "advisors"."spouse_name" AS t0_r3,
"advisors"."spouse_dob" AS t0_r4, "advisors"."anniversary" AS t0_r5,
"advisors"."comment" AS t0_r6, "advisors"."created_at" AS t0_r7,
"advisors"."updated_at" AS t0_r8, "people"."id" AS t1_r0,
"people"."organization_id" AS t1_r1, "people"."advisor_id" AS t1_r2,
"people"."personable_id" AS t1_r3, "people"."personable_type" AS t1_r4,
"people"."first_name" AS t1_r5, "people"."middle_initial" AS t1_r6,
"people"."last_name" AS t1_r7, "people"."suffix" AS t1_r8,
"people"."nickname" AS t1_r9, "people"."ssn" AS t1_r10, "people"."dob" AS
t1_r11, "people"."created_at" AS t1_r12, "people"."updated_at" AS t1_r13
FROM "advisors" LEFT OUTER JOIN "people" ON "people".personable_id =
"advisors".id AND "people".personable_type = E'Advisor'WHERE
("advisors".organization_id = 1) AND ((people.ssn LIKE E'%Annuity%' or
to_tsvector(people.first_name || '' || people.last_name) @@ E'Annuity%') AND
("advisors".organization_id = 1)) ORDER BY people.first_name ASC,
people.last_name ASC, advisors.updated_at DESC LIMIT 15 OFFSET 0

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Edwin Quijada 2009-08-05 00:21:37 Combinaciones en Select
Previous Message Santiago Zarate 2009-08-04 19:00:25 Re: Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation