On Tue, 2006-08-15 at 18:05 +0200, Max wrote: > Do you know if it is possible to write such things : > > SELECT * FROM tablename WHERE permission(some parameters) == TRUE; > > with the function 'permission' returning TRUE or FALSE after a check > on different perm_fields of the current row. Yes, you can do that. The best place to start is: http://www.postgresql.org/docs/8.1/static/plpgsql.html You want to create a pretty basic function that returns "boolean" and takes a few parameters. Note that SQL does not have the C-style "==" equality test. In SQL just write "= true". Better yet, since your function returns boolean just do "WHERE permission(...)" with "..." replaced by your parameters. If you have trouble after trying out some examples at that link, post back to the list with what you tried. Regards, Jeff Davis
