2011/2/1 Robert Haas <robertmhaas@gmail.com>:
> On Mon, Jan 31, 2011 at 11:41 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
>> CREATE METHOD next_color (n INT)
>> RETURNS INT
>> FOR colored_part_t
>> RETURN SELF.color_id + n
>>
>> SELECT partno, color_id, DEREF(oid).next_color(1) AS next
>> FROM colored_parts
>
> DEREF(oid)? That's just bizarre.
>
have to look on this topic more complex :). There are some papers.
It's sadly so these features wasn't used more and world is controlled
by ORMs like Hibernate and company :(
We did a some OOP meta language -> PL/pgSQL translator and lot of
tasks was processed simply without deep SQL programming.
It was a strange tool :) - compiler to PL/pgSQL in PL/pgSQL :)
Regards
Pavel Stehule
> --
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>