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