From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Query using 'LIKE' returns empty set |
Date: | 2019-08-29 16:39:24 |
Message-ID: | alpine.LNX.2.20.1908290903030.2953@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Next problem is one I've not before encountered.
The .sql file used to import data to the fish_counts table has rows such as
this one:
('1237796458250','0','17174','Buchanan Creek','Buchanan Creek trib to North
Fork Nehalem River','0-3.25','161980','Unknown','Jack or subadult','Peak
live & dead fish','Spawner Counts','ODFW','2012-01-06','1950-1974',25,
'1950-10-01','1951-01-31','Ground','Actual Physical Counts',0),
[Lines wrapped in the message only.]
When I submit this query I get no rows returned:
select * from fish_counts where stream_tribs ilike 'Nehalem';
count_id | loc_id | downstream | upstream | stream_name | stream_tribs | r
iver_miles | itis_tsn | production | life_stage | count_type | data_categor
y | compiled_by | updated | years | nbr_observations | begin_date | end_dat
e | sample_method | calc_method | count_value
----------+--------+------------+----------+-------------+--------------+--
-----------+----------+------------+------------+------------+-------------
--+-------------+---------+-------+------------------+------------+--------
--+---------------+-------------+-------------
(0 rows)
What is equally puzzling is when I search the input file using
grep -c -e "Nehalem" fish_counts
0 is returned, the same as the postgres query.
I want to understand what I've done incorrectly.
TIA,
Rich
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Sargent | 2019-08-29 16:58:52 | Re: Query using 'LIKE' returns empty set |
Previous Message | Rich Shepard | 2019-08-29 16:02:51 | Re: Selecting rows having substring in a column [RESOLVED] |