[GENERAL] Use functions in Pl/Perl language

2006-03-30 Thread sylsau
Hello, I would like to create a function that lets me to search in a table rows according differents parameters. I looked in the documentation of postgresql 8.1 about Pl/Perl procedures but I didn't found how to cross each row of a table with Pl/Perl. Someone would have an example of that with Pl

[GENERAL] Create an index with a sort condition

2006-03-29 Thread sylsau
Hello, I use PostgreSQL 8.1 and I would like create and index on a table's field with a sort condition on this field. For example, I have a table named books and I want create an index on the fields title and id_book with an order by id_book descendant. I know how to create the index without this

Re: [GENERAL] Questions about privileges

2006-03-05 Thread sylsau
Thanks, it's a good idea. Someone can help me with the two others question (the index and the update of the structure of the table) ? ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an ind