What's wrong with this query?
От | Mike Christensen |
---|---|
Тема | What's wrong with this query? |
Дата | |
Msg-id | AANLkTinPRj7ZT_09erDtjvEnxsJScF-8sgcKoKqQ3R6e@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: What's wrong with this query?
|
Список | pgsql-general |
Here's the query: SELECT R.RecipeId, R.Title, R.Description, R.ImageUrl, R.Rating, R.PrepTime, R.CookTime, R.OwnerId, U.Alias, ts_rank_cd(R.TextSearch, query) as Rank FROM Recipes R, plainto_tsquery('veggie burgers') query INNER JOIN Users U ON U.UserId = R.OwnerId WHERE (R.TextSearch @@ query) AND NOT EXISTS (select 1 from RecipeIngredients inner join IngredientBlacklist using (IngredientId) where RecipeId = r.RecipeId and IngredientBlacklist.UserId = 'affaa328-5b53-430e-991a-22674ede6faf' limit 1) ORDER BY Rank DESC LIMIT 100; Here's the error: ERROR: invalid reference to FROM-clause entry for table "r" LINE 3: INNER JOIN Users U ON U.UserId = R.OwnerId ^ HINT: There is an entry for table "r", but it cannot be referenced from this part of the query. ********** Error ********** ERROR: invalid reference to FROM-clause entry for table "r" SQL state: 42P01 Hint: There is an entry for table "r", but it cannot be referenced from this part of the query. Character: 239 This seems to happen when I add the fulltext functions. Thanks! Mike
В списке pgsql-general по дате отправления: