Re:

[Jeff Davis <pgsql@xxxxxxxxxxx>]

On Tue, 2006-08-15 at 18:46 +0200, Max wrote:
> Thx.
> But I know how to write procedure and function, but my problem is to  
> know how to access the current row fields during a SELECT inside a  
> function:
> 
> So, in a function, can I write :
> 
> /* ... */ permission (/* ... */)
> /* ... */
> IF (ROW.perm_field1 = 1)
> 	statement
> IF (some_operation(ROW.perm_field2))
> 	statement
> /* ... */
> RETURN TRUE or FALSE;
> /* ... */
> 

What you want to do is pass each "perm_field" as a parameter.

So, you'd do something like:

CREATE OR REPLACE FUNCTION permission(perm_field1 int, perm_field2 int,
perm_field3 int) RETURNS BOOLEAN LANGUAGE plpgsql STABLE AS $$
BEGIN
IF perm_field1 = 2 THEN
	RETURN FALSE;
ELSIF perm_field2 = perm_field3 THEN
	RETURN TRUE;
ELSE
	RETURN FALSE;
END IF;
END;
$$;

And then:

SELECT * FROM tablename WHERE permission
(perm_field1,perm_field2,perm_field3);

Hope this helps,
	Jeff Davis