[SQL] SQL select count(*) from "myTable" failed : Relation "mytable" does not exist

2002-12-20 Thread Jeff Kowalczyk
What do these errors mean? I get them on certain databases when trying to view table data in webmin's postgresql module. I don't think its Webmin specific. The databases in question are often exported from Access XP using pgAdmin 1.4.2 and the migration plugin (and imported using psql -f), but I al

Re: [SQL] SQL -select count-

2002-11-26 Thread Achilleus Mantzios
On Tue, 19 Nov 2002, Giannis wrote: > when I do : > > select count(column_name) from table_name > > should I get the count for all columns or just those which are not null? &Ggr;&igr;&aacgr;&ngr;&ngr;&eegr;, &thgr;&agr; &pgr;&aacgr;&rgr;&egr;&igr;&sfgr; &tgr;&ogr; &pgr;&lgr;&eeacgr;&thgr;&ogr;&sf

Re: [SQL] SQL -select count-

2002-11-26 Thread Richard Huxton
On Tuesday 19 Nov 2002 5:06 pm, Giannis wrote: > when I do : > > select count(column_name) from table_name > > should I get the count for all columns or just those which are not null? Just "not null" - use count(*) or count(0) for a count of rows. -- Richard Huxton ---

[SQL] SQL -select count-

2002-11-26 Thread Giannis
when I do : select count(column_name) from table_name should I get the count for all columns or just those which are not null? __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com