2011/2/1 Robert Haas <robertmh...@gmail.com>: > On Mon, Jan 31, 2011 at 11:41 PM, Pavel Stehule <pavel.steh...@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 > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers