Re: [HACKERS] "internal error" triggered by EXISTS()

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: David Gould <dg(at)illustra(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)hub(dot)org
Subject: Re: [HACKERS] "internal error" triggered by EXISTS()
Date: 1998-07-15 02:41:09
Message-ID: 35AC16C5.C0B9C32F@krs.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

David Gould wrote:
>
> >
> > I tried the following to find out whether a table has any records
> > with field1 < X (for a constant X):
> >
> > tgl=> SELECT EXISTS(SELECT * FROM table WHERE field1 < X);
> > ERROR: internal error: do not know how to transform targetlist
>
> Should have given a syntax error probably. But you might try:
>
> select 1 where exists (select...);
>
> Should be faster if and only if we are doing the existential query
> optimization trick (stop on the first qualifying row).

We do.

Vadim

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-07-15 02:45:30 Re: [HACKERS] "internal error" triggered by EXISTS()
Previous Message Vadim Mikheev 1998-07-15 02:29:31 Re: [HACKERS] SEQUENCES and COPY FROM