On Fri, 31 Oct 2003 13:33:09 -0600 "PostgreSQL" <[EMAIL PROTECTED]> wrote:
> I have instaled Postgres 7.3.4 on RH 9, > if I excecute: > > select count(*) from cj_tranh; > count > ------- > 0 > (1 row) > > Why the result us CERO? the table have 1.400.000 rows! > What is wrong? Anybody help please. > 1. did you remember to load data? 2. did someone accidentally delete the data? 3. are you connected to the correct db (I've panic'd before but realized I was on dev, not production!)? 4. sure that is the right table? -- Jeff Trout <[EMAIL PROTECTED]> http://www.jefftrout.com/ http://www.stuarthamm.net/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match