Re: filtering after join

andrew <andrew.ylzhou@gmail.com> writes:
> I got errors in this query. I have a function complete(record) which
> takes a generic record type data. But it seems cannot be applied to a
> sub-select result:

As I seem to recall having mentioned several times already, PG 7.3 is
really, really weak in this area.  (If you ever got it to work, which
I doubt you will, you'd probably then start to notice how badly it
leaks memory for whole-row operations...)

You should either forget this idea or invest the effort to move up
to PG 8.1.
        regards, tom lane