Re: [pgsql-general 2011-1-21:] Are there any projects interested in object functionality? (+ rule bases)

2011/2/1 Robert Haas <robertmhaas(at)gmail(dot)com>:
> On Mon, Jan 31, 2011 at 11:41 PM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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
>