"Gevik Babakhani" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
