Re: no records returned - Mailing list pgsql-general

Patrick,

James Moe <jimoe@sohnen-moe.com>
also suggested this...

It WORKS!!!

Could you explain to a newbie WHY the like and % at
the end of the literal works when the normal select does
not?

Thanks,
Lynn

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

> 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
>