ERROR: JoinClauseSelectivity
От | sheila bel |
---|---|
Тема | ERROR: JoinClauseSelectivity |
Дата | |
Msg-id | 20000223060709.83697.qmail@hotmail.com обсуждение исходный текст |
Ответы |
Re: [GENERAL] ERROR: JoinClauseSelectivity
|
Список | pgsql-general |
Hi everyone, I'm trying to do a simple join query and I get an error message. My tables are : agency(agencyid serial, agency_name text, address text, ...) groupleader(leaderid serial, agency_name text, phonenum text , ...) The query : SELECT agencyid FROM agency, groupleader WHERE agency.agency_name=groupleader.agency_name; The error message : ERROR: JoinClauseSelectivity: bad value 2.450299 I tried the query in other forms such as: SELECT * FROM agency, groupleader WHERE agency.agency_name=groupleader.agency_name; and SELECT * FROM agency WHERE agency_name=groupleader.agency_name; I get the same error message. What am I doing wrong here ? Thanks for your help, -Sheila ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com
В списке pgsql-general по дате отправления: