Re: no records returned

is it possible that there are spaces on the end?   what type is
stck_sym?  if it's varchar or text the padding won't be removed
automatically.

example:

basement=# create table test (t varchar(6));
CREATE TABLE
basement=# INSERT into test values( 'ZRAN  ');
INSERT 92249850 1
basement=# select * from test where t = 'ZRAN';
  t
---
(0 rows)

basement=#


On Oct 24, 2003, at 5:27 PM, Lynn.Tilby@asu.edu wrote:

>
> 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
>
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster