Postgres Pro
Downloads
Home   >   mailing lists

Re: Identifying Reason for Column Name Returned by SELECT - Mailing list pgsql-general

From Darren Duncan
Subject Re: Identifying Reason for Column Name Returned by SELECT
Date
Msg-id 4E70DDC5.1090103@darrenduncan.net
Whole thread Raw
In response to Re: Identifying Reason for Column Name Returned by SELECT  (Darren Duncan <darren@darrenduncan.net>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Richard Broersma
Date:
Subject: Re: Identifying Reason for Column Name Returned by SELECT
Next
From: Rich Shepard
Date:
Subject: Re: Identifying Reason for Column Name Returned by SELECT