Re: Getting relation/attribute names from inside UDT input/output function

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Humberto Luiz Razente <hlr(at)icmc(dot)usp(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Getting relation/attribute names from inside UDT input/output function
Date: 2006-05-11 03:12:33
Message-ID: 20060511031233.GA18375@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

[Please copy the mailing list on replies so others can contribute
to and learn from the discussion.]

On Wed, May 10, 2006 at 02:50:26PM -0300, Humberto Luiz Razente wrote:
> I'm trying to index data characteristics extracted from multimedia
> files (like a color distribution histogram from an image), in
> order to make k-nearest neighbor queries (similarity-based queries).
> The problem is that I can have a variable number of characteristics (its
> called adimensional features), so I cannot index with R-tree
> like GIST. I already have the tree implemented in C, so I would
> like to build a tree for each complex type in each
> attribute/relation. Am I going in the wrong direction?

I'm not familiar with the problem domain but maybe somebody else
on the mailing list is. Could you explain a bit more, perhaps with
an example showing how you're currently using the type and what
you'd like to be able to do with it (e.g., a hypothetical table,
data set, query, and query result)?

--
Michael Fuhr

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shoaib Mir 2006-05-11 04:15:31 Recovery problem with PostgreSQL
Previous Message APSC, Patrick Chee Seng Onn 2006-05-11 02:35:12 Creating of User and Database