| Lists: | pgsql-sql |
|---|
| 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 |
| 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
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Evgen Potemkin <evgent(at)ns(dot)terminal(dot)ru> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Filter function |
| Date: | 2003-01-29 08:25:57 |
| Message-ID: | 21291.1043828757@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-sql |
Evgen Potemkin <evgent(at)ns(dot)terminal(dot)ru> writes:
> term2=>select * from tab where tab=1;
> ERROR: exprType: Do not know how to get type for 711 node
What release is this? I get
Relation reference "tab" cannot be used in an expression
in 7.3 and CVS tip, and
Attribute 'tab' not found
in prior releases.
regards, tom lane
| From: | Evgen Potemkin <evgent(at)ns(dot)terminal(dot)ru> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Filter function |
| Date: | 2003-01-30 08:27:35 |
| Message-ID: | Pine.LNX.4.33.0301301226340.3316-100000@ns.terminal.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-sql |
it's base-7.3.1 from one of the russian mirrors.
regards,
---
.evgen
On Wed, 29 Jan 2003, Tom Lane wrote:
> Evgen Potemkin <evgent(at)ns(dot)terminal(dot)ru> writes:
> > term2=>select * from tab where tab=1;
> > ERROR: exprType: Do not know how to get type for 711 node
>
> What release is this? I get
> Relation reference "tab" cannot be used in an expression
> in 7.3 and CVS tip, and
> Attribute 'tab' not found
> in prior releases.
>
> regards, tom lane
>
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Evgen Potemkin <evgent(at)ns(dot)terminal(dot)ru> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Filter function |
| Date: | 2003-01-30 14:56:04 |
| Message-ID: | 19272.1043938564@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-sql |
Evgen Potemkin <evgent(at)ns(dot)terminal(dot)ru> writes:
> it's base-7.3.1 from one of the russian mirrors.
Oh, it must be a post-7.3.1 fix then [ ... checks CVS logs ... ] ah,
here it is:
2002-12-27 15:06 tgl
* src/backend/parser/parse_expr.c (REL7_3_STABLE): Deliver better
error message when a relation name is used in an expression. Per
report from Ian Barwick.
This will be in 7.3.2, due out next week.
regards, tom lane