[GENERAL] Separating function privileges from tables

2007-05-03 Thread Barry Brown
Hi all, It's nice that privileges on views are separate from the privileges on its underlying tables. For example, if view V queries tables A and B, I only need to grant SELECT on the view to another user; tables A and B can have that privilege revoked and the view works. Are there plans

[GENERAL] Indexing of geometric data

2000-07-05 Thread Barry Brown
Greetings, I'm investigating the use of PostgreSQL to maintain a database of mapping data. My dataset currently stored latitudes and longitudes as fixed-precision integers (ie, 37.234 is stored as 37234) in separate columns: one for latitude, one for longitude. Postgres has geometric data types