Hi to Everyone.
To select a last n no. of records from table in the database i used the
following query in PostgreSQL
select * from stocks offset(select count(*) -3 from stocks);
output:
no | stkdate | stktime | itemcode | itemname | quantity
| rate | totamount
-----+------------+----------+----------+-------------------------+----------+--------+------------------------------
3 | 2010-10-19 | 11:44:41 | 606 | lemon |
2 | 100.00 | 200.00
1 | 2010-10-19 | 11:49:04 | 903 | Karaboondhi |
8 | 100.00 | 800.00
3 | 2010-10-19 | 11:49:04 | 907 | Ola pakoda |
6 | 100.00 | 600.00
While am doing the same process from python code it displays output as None.
Note: Assume that value of self.cou is 3
Bit of python code:
print self.cou
disp=cur.execute("""select * from sales offset(select count(*)%d
from sales);""" %self.cou)
print disp
print type(disp)
output:
3
None
<type 'NoneType'>
Need help. for this problem
If some other query is there for this kind of process?
kindly mention the query.
Thanks in advance.
--
நன்றி ....
சண்முகசுந்தரம்.க
Kanchi Linux User Group Rocks !
http://kanchilug.wordpress.com
My Experiments In Linux are here
http://gowithfoss.wordpress.com/
_______________________________________________
ILUGC Mailing List:
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
