Re: [GENERAL] select from dynamic table names

2011-11-10 Thread Pavel Stehule
Hello 2011/11/8 Dinesh Kumara > ** > I have 16 tables which created according to generated MD5 hash. > At the time of execution i tried to retrieve data from a table where table > name id dynamic. > > table name can be expertdb.rate_AVAIL_[0 to F] > > I tried to get this from ; > SELECT * FROM e

[GENERAL] select from dynamic table names

2011-11-10 Thread Dinesh Kumara
I have 16 tables which created according to generated MD5 hash. At the time of execution i tried to retrieve data from a table where table name id dynamic. table name can be expertdb.rate_AVAIL_[0 to F] I tried to get this from ; SELECT * FROM expertdb.rate_AVAIL_ || upper(substring(md5('2011