Horton

Re: [PATCH 4/4] Add tests to dblink covering use of COPY TO FUNCTION

Daniel Farina <drfarina@gmail.com>

View thread View on postgr.es
From: Daniel Farina <drfarina@gmail.com>
To: Hannu Krosing <hannu@2ndquadrant.com>
Cc: Daniel Farina <dfarina@truviso.com>, Tom Lane <tgl@sss.pgh.pa.us>, Greg Smith <greg@2ndquadrant.com>, Robert Haas <robertmhaas@gmail.com>, pgsql-hackers@postgresql.org
Date: 2009-11-24T08:57:02Z
Lists: pgsql-hackers 
On Tue, Nov 24, 2009 at 12:38 AM, Hannu Krosing <hannu@2ndquadrant.com> wrote:
> COPY func(rowtype) FROM stdin;

I didn't consider rowtype...I did consider a type list, such as:

COPY func(typea, typeb, typec) FROM ...

Which would then operate just like a table, but be useless for the
data-cleaning case, and would not allow type overloading to be the
mechanism of selecting behavior.

It was just an idea...I don't really know the use cases well enough,
my anticipated used case was updating eagerly materialized quantities
with the UDF.

fdr