Re: no records returned - Mailing list pgsql-general

From Lynn.Tilby@asu.edu
Subject Re: no records returned
Date
Msg-id 1067136532.3f9b36142ec96@webmail.asu.edu
Whole thread Raw
In response to Re: no records returned  (darren@crystalballinc.com)
List pgsql-general
Darren,

Thanks for the thoughts...

stck_sym is a varchar the rest are int's and floats's.

Do you think that the size of the table could be part of the problem,
at 600000+ records?

Lynn
> exact amount in the field. i.e.
>
> char(5)
>
> da will be padded da and 0s on the end up to the sizeof the char
> field.
>
> If varchar then you will be ok.
>
> If you do have a char then use the trim function to do the selects
>
> HTH
> Darren
>
> On Fri, 24 Oct 2003 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
> >
>
> --
> Darren Ferguson
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>


pgsql-general by date:

Previous
From: Adam Witney
Date:
Subject: Re: shared memory on OS X - 7.4beta4
Next
From: nzanella@cs.mun.ca (Neil Zanella)
Date:
Subject: incrementing and decrementing dates by day increments programmatically