Skip site navigation (1) Skip section navigation (2)

Syntax Error?

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 (view raw or flat)
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

Responses

pdxpug by date

Next:From: Jeff DavisDate: 2011-02-03 18:18:32
Subject: Re: Syntax Error?
Previous:From: David E. WheelerDate: 2011-02-03 17:06:28
Subject: Re: Date Format Question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group