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