Re: Finding rows with text columns beginning with other text columns

From: Christoph Zwerschke <cito(at)online(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Finding rows with text columns beginning with other text columns
Date: 2010-05-11 21:04:00
Message-ID: 4BE9C640.1020106@online.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am 10.05.2010 23:34 schrieb Alban Hertroys:
> Thinking more on the issue, I don't see a way to prevent the nested
> loop as there's no way to decide beforehand what part of the string to
> index for b.txt. It depends on a.txt after all.

Yes, that seems to be the gist of the matter. I just felt I might have
missed something. Thanks for your answers.

-- Christoph

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-05-11 21:29:04 Re: Moving postgresql data to another computer
Previous Message Richard Broersma 2010-05-11 21:00:33 Re: Moving postgresql data to another computer