Re: Need for advice and direction (again)

"Gevik Babakhani" <pgdev(at)xs4all(dot)nl> writes:
> How should we refer to emp in the following example.

> CREATE FUNCTION double_salary(PARAM1 emp) RETURNS numeric AS $$

> -- At this moment PARAM1.salary will fail because PARAM1
> -- is compared to the name of this function
> SELECT PARAM1.salary * 2 AS salary;

It'd need to be

SELECT (PARAM1).salary * 2 AS salary;

This is already the case in other usages of composite types.

regards, tom lane