Re: no records returned

From: Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk>
To: Lynn(dot)Tilby(at)asu(dot)edu
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: no records returned
Date: 2003-10-25 17:42:11
Message-ID: 20031025184211.D982@quartz.newn.cam.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Oct 24, 2003 at 04:27:16PM -0700, Lynn(dot)Tilby(at)asu(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Reece Hart 2003-10-25 17:49:00 explicit casting required for index use
Previous Message Marco Colombo 2003-10-25 16:27:00 Re: [OT] Choosing a scripting language.