From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pdxpug(at)postgresql(dot)org |
Subject: | Syntax Error? |
Date: | 2011-02-03 18:10:00 |
Message-ID: | alpine.LNX.2.00.1102031003470.25032@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pdxpug |
My cold can't be so bad that I cannot write a simple SELECT statement,
but that's how it appears this morning. When I run this query I get no rows
returned:
jerrittwq=# select * from monitor where location = 'GW-24';
record | sample_id | location | sample_date | parameter | quant | units |
quali
ty
--------+-----------+----------+-------------+-----------+-------+-------+------
---
(0 rows)
Yet, there are multiple rows with location = 'GW-24':
jerrittwq=# select distinct location from monitor;
location
------------------
<snip>
'OMW-9'
'GW-24'
'FC-2'
What simple thing am I not seeing in my select statement?
Rich
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Davis | 2011-02-03 18:18:32 | Re: Syntax Error? |
Previous Message | David E. Wheeler | 2011-02-03 17:06:28 | Re: Date Format Question |