Re: Identifying Reason for Column Name Returned by SELECT

From: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
To: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
Cc: Rich Shepard <rshepard(at)appl-ecosys(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Identifying Reason for Column Name Returned by SELECT
Date: 2011-09-14 16:48:25
Message-ID: CABvLTWGhUCTnv6bEg0BcYGdnmzLBz9bWZsO25Excn=v=LZfG4A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Sep 14, 2011 at 9:42 AM, Steve Crawford
<scrawford(at)pinpointresearch(dot)com> wrote:

> I suspect you have a multi-line entry and the '+' is just indicating that
> the field continues.
>
> Try ...where site_id ~ 'GW-22'... (this may take a while if the table is
> very large).

You might be able to get an index scan if you include a few more criteria:

AND site_id BETWEEN 'GW-22' AND 'GW-23'

Also WHERE site_id '^GW-22' may use and index scan also.

--
Regards,
Richard Broersma Jr.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Darren Duncan 2011-09-14 17:00:53 Re: Identifying Reason for Column Name Returned by SELECT
Previous Message Robert Treat 2011-09-14 16:46:05 Re: PostgreSQL benchmarked on XFS vs ZFS vs btrfs vs ext4