Re: [GENERAL] ERROR: JoinClauseSelectivity

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: sheila bel <sheilabel(at)hotmail(dot)com>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] ERROR: JoinClauseSelectivity
Date: 2000-02-23 15:39:50
Message-ID: 200002231539.KAA28348@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

VACUUM ANALYZE the table.

> 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
>
>
> ************
>
>

--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-02-23 15:54:46 Re: AW: [HACKERS] TRANSACTIONS
Previous Message Don Baccus 2000-02-23 15:30:28 Re: AW: [HACKERS] TRANSACTIONS