kirang@it.iitb.ac.in wrote: > hi all, > > I am an M.Tech student of IITBombay,india. > We are doing a project on access control in postgres. > > Is there any way in which, i can add a extra predicate to the sql query > given to the postgres database table. > > please if any body could help me in this regard. Reply as soon as posible. Look at views or rules as a way to create a predicate based on an existing table. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)