Re: Need for advice and direction (again) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Need for advice and direction (again)
Date
Msg-id 7320.1194659583@sss.pgh.pa.us
Whole thread Raw
In response to Need for advice and direction (again)  ("Gevik Babakhani" <pgdev@xs4all.nl>)
List pgsql-hackers
"Gevik Babakhani" <pgdev@xs4all.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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: autovacuum_freeze_max_age
Next
From: Bruce Momjian
Date:
Subject: Re: [BUGS] Nasty tsvector can make dumps unrestorable