RE: [GENERAL] Trigger with superuser privileges

2000-12-19 Thread Edmar Wiggers
> Anobody could tell-me how can I make a Trigger thats execute some things > whith "postgres" superuser privileges (like INSERT INTO a table that the > user logged in don't have access) I think triggers should run with table-owner user permissions. That way you could have a table owned by superus

[GENERAL] prefer (+) oracle notation

2000-10-19 Thread Edmar Wiggers
I'm not sure about the standard, but I really like Oracle's notation for foreign keys: select a.item_number, b.group_code_description from items a, group_codes b where a.group_code = b.group_code (+); Much better than select a.item_number, b.group_code_descriptio

[GENERAL] C function returning rows, was Boolean text, with phrase ranking, search under Postgres

2000-10-16 Thread Edmar Wiggers
I too am interested in full text indexing under PostgreSQL. Moreover, I have run into the same problem as you (in a different project though): how do you return more than 1 value from a C function? I'd like to return "rows", but, if at all possible, NOT to create a table. How about a cursor? Perh