On Wed, Nov 13, 2002 at 07:56:38AM -0500, Andrew Sullivan wrote:
> I'll bet it had to do with a funky path I had, though; probably I
> picked up a different awk (there are two on Solaris), because I was
> also working on another problem during the same period. (I can try
For the record, I did co
I am having an optimization problem with queries that include IN clauses
and subselects.
xxx=> select version();
version
-
PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96
The basic query I have is
Hi all,
I have searched through the archives but after 2 days
of trying, I still cannot figure out how to get
postgres permissions to work the way I need them to.
What I am trying to do is setup Postgresql on a Linux
server so that users can connect from anywhere on the
subnet and edit tables t
"Marc Mitchell" <[EMAIL PROTECTED]> writes:
> I am having an optimization problem with queries that include IN clauses
> and subselects.
The optimizer currently has no clue at all about dealing with
"IN (subselect)", and always converts it into the worst sort of
nested-loop plan. I'm hoping to do