On Fri, Oct 24, 2003 at 04:27:16PM -0700, [EMAIL PROTECTED] 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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to