Horton

Re: no records returned

Patrick Welche <prlw1@newn.cam.ac.uk>

View thread View on postgr.es
From: Patrick Welche <prlw1@newn.cam.ac.uk>
To: Lynn.Tilby@asu.edu
Cc: pgsql-general@postgresql.org
Date: 2003-10-25T17:42:11Z
Lists: pgsql-general 
On Fri, Oct 24, 2003 at 04:27:16PM -0700, Lynn.Tilby@asu.edu wrote:
...
> ZRAN    |2003-10-03|    20031003|      731491|     20.25|      21.
> (609398 rows)

> pma=> select * from stck_dta_tbl_oprtnl where stck_sym = 'ZRAN';

How about

pma=> select * from stck_dta_tbl_oprtnl where stck_sym like 'ZRAN%';

? (What is the definition of your table?)

Cheers,

Patrick