AW: AW: AW: functions returning records - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: AW: AW: functions returning records
Date
Msg-id 11C1E6749A55D411A9670001FA687963368351@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
Responses Re: AW: AW: AW: functions returning records  (Alex Pilosov <alex@pilosoft.com>)
List pgsql-hackers
> > In my setup the function would be hidden by a view.
> Its a different problem. Functions returning tables do just that, return
> tables, they won't care just what from that table you need. Exposing
> pieces of optimizer to your function doesn't seem to me like a great
> idea...

Ok, I think i need to go into a little more detail to explain.
My function needs to construct a table from the where condition.
If no where condition is present the result set would be near infinite
in size (all possible permutations of all possible field values
e.g. 2^32 for a table with one int column).

The function answers queries about rows that are not in the table,
but the result is based on rows that are in the table and computed
by a neural net.

Andreas


pgsql-hackers by date:

Previous
From: Alex Pilosov
Date:
Subject: Re: AW: functions returning records
Next
From: Alex Pilosov
Date:
Subject: Re: AW: AW: AW: functions returning records