Hi,
the query is running fine but i cannot EXPLAIN or (ANALYZE)
it.
I am seeing this message for the first time:
tradein_clients=# SELECT count(*) from shippers1 where city='DELHI';
+-------+
| count |
+-------+
| 2 |
+-------+
(1 row)
tradein_clients=#
tradein_clients=# explain SELECT count(*) from shippers1 where city='DELHI';
ERROR: get_names_for_var: bogus varno 5
tradein_clients=#
i can paste the nasty view definations if nothing is obvious till
now.
regds
MAllah.
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)26152172 (221) (L) 9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.