From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Joseph Shraibman <jks(at)selectacast(dot)net> |
Cc: | pgsql-sql <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: exists |
Date: | 2001-08-21 16:45:25 |
Message-ID: | Pine.BSF.4.21.0108210941300.5842-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Tue, 21 Aug 2001, Joseph Shraibman wrote:
> Thank you, I was missing the parens.
>
> If I do an explain I see:
>
> -> Index Scan using m_u_and_p_key on m (cost=0.00..3035.22 rows=1363 width=12)
>
>
> even if I put a limit 1 on the select. Why is that?
Is that the inner query (on the exists) or the entire explain?
I guess it'd be useful to see the whole query and explain and maybe
schema.
> Stephan Szabo wrote:
> > On Mon, 20 Aug 2001, Joseph Shraibman wrote:
> >
> >
> >>I want to select a boolean if there exists a row in another table that matches this one.
> >>So I did select ..., (select count(*) from table2 where ...) > 0 ...
> >>but that count(*) was taking forever. I know there is a better way to do it, but whenever
> >>I try to use EXISTS I get a syntax error. What is the proper way?
> >>
> >
> > Hmm, on current sources I can do:
> > select ..., exists (select * from table2 where ...) from table1;
> >
> > I don't know if that's new though...
From | Date | Subject | |
---|---|---|---|
Next Message | Joseph Shraibman | 2001-08-21 17:29:38 | Re: exists |
Previous Message | Albert REINER | 2001-08-21 16:23:16 | Re: How to execute a system file in procedure? |