Filter function

From: Evgen Potemkin <evgent(at)ns(dot)terminal(dot)ru>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Filter function
Date: 2003-01-25 12:06:38
Message-ID: Pine.LNX.4.33.0301251553480.22969-100000@ns.terminal.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello there!

is there any way to create filter function?
i.e. function which will be accepting and returning row sets, like

select foo(t) from (select blah from tab) t;
something like this.

contrib/tablefunc seems not accepting a row set.

also, not related to above, i've typed query:

term2=>select * from tab where tab=1;
ERROR: exprType: Do not know how to get type for 711 node

i know that query is wrong, but may be there must be more understandable error
message?

regards,

---
.evgen

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message jack 2003-01-26 02:29:12 Re: quastions about primary key
Previous Message Guy Fraser 2003-01-25 01:42:39 Re: Getting multiple rows in plpgsql function