Re: Identifying Reason for Column Name Returned by SELECT

From: Darren Duncan <darren(at)darrenduncan(dot)net>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Identifying Reason for Column Name Returned by SELECT
Date: 2011-09-14 17:00:53
Message-ID: 4E70DDC5.1090103@darrenduncan.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Darren Duncan wrote:
> Try "like" by default, such as "where site_id like 'GW-22 %'". I added
> the space between the 22 and the wildcard % so that the field containing
> just 'GW-22' isn't also matched.

Sorry, I should have said "where site_id like 'GW-22%' and site_id != 'GW-22'"
(no explicit space) as a better way to exclude 'GW-22' from the results. --
Darren Duncan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2011-09-14 17:04:51 Re: Identifying Reason for Column Name Returned by SELECT
Previous Message Richard Broersma 2011-09-14 16:48:25 Re: Identifying Reason for Column Name Returned by SELECT