Re: table inheritance and polymorphic functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David(dot)Ventimiglia(at)wellsfargo(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: table inheritance and polymorphic functions
Date: 2004-07-10 03:16:26
Message-ID: 2184.1089429386@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

David(dot)Ventimiglia(at)wellsfargo(dot)com writes:
> Is there any way to set up overloaded functions whose parameters are
> composite types (i.e., row types) within a table inheritance hierarchy, so
> that postgresql dispatches to the correct function depending on the actual
> type of its argument, in an "object-oriented" fashion?

AFAIK this has always worked: functions on parent tables can be called
on rows of child tables. What problem are you hitting exactly (and
which PG version are you trying it in)?

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2004-07-10 04:14:17 Re: Extended Query: Parse Command: syntax?
Previous Message Tom Lane 2004-07-10 00:59:40 Re: .pgpass