no records returned
От | Lynn.Tilby@asu.edu |
---|---|
Тема | no records returned |
Дата | |
Msg-id | 1067038036.3f99b55430672@webmail.asu.edu обсуждение исходный текст |
Ответы |
Re: no records returned
Re: no records returned Re: no records returned |
Список | pgsql-general |
running - (PostgreSQL) 7.1.3 I have loaded a table with stock market data. - - - ZRAN |2003-09-29| 20030929| 731487| 20.81| 20. ZRAN |2003-09-30| 20030930| 731488| 19.43| 20.1 ZRAN |2003-10-01| 20031001| 731489| 19.82| 19.9 ZRAN |2003-10-02| 20031002| 731490| 19.56| 20.3 ZRAN |2003-10-03| 20031003| 731491| 20.25| 21. (609398 rows) pma=> select count(*) from stck_dta_tbl_oprtnl; count ------ 609398 When I do a select * from stck_dta_tbl_oprtnl; I get the whole table just fine; but when I try and retrieve just 1 record which is out put when doing the select * ie: pma=> select * from stck_dta_tbl_oprtnl where stck_sym = 'ZRAN'; stck_sym|dta_date|dta_date_num|dta_date_dys|opn|hi|lw|cls|vol|unk --------+--------+------------+------------+---+--+--+---+---+--- (0 rows) I get 0 rows, and no errors from postmaster. Is there a limit to the number of rows in a table? I have also tried building a unique index composed of the stck_sym and dta_date but I still get 0 rows. I have also noticed that when setting up a cursor that the first fetch does NOT get the first record in the table, it also returns nothing with no errors from the postmaster. I am wondering if these bugs are related. Thanks all for your help!!!! Lynn
В списке pgsql-general по дате отправления: