pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedFilter function
4+ messages / 2 participants
[nested] [flat]
* Filter function
@ 2003-01-25 12:06 Evgen Potemkin <evgent@ns.terminal.ru>
0 siblings, 1 reply; 4+ messages in thread
From: Evgen Potemkin @ 2003-01-25 12:06 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Filter function
@ 2003-01-29 08:25 Tom Lane <tgl@sss.pgh.pa.us>
parent: Evgen Potemkin <evgent@ns.terminal.ru>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2003-01-29 08:25 UTC (permalink / raw)
To: Evgen Potemkin <evgent@ns.terminal.ru>; +Cc: pgsql-sql
Evgen Potemkin <evgent@ns.terminal.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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Filter function
@ 2003-01-30 08:27 Evgen Potemkin <evgent@ns.terminal.ru>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Evgen Potemkin @ 2003-01-30 08:27 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: 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@ns.terminal.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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Filter function
@ 2003-01-30 14:56 Tom Lane <tgl@sss.pgh.pa.us>
parent: Evgen Potemkin <evgent@ns.terminal.ru>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2003-01-30 14:56 UTC (permalink / raw)
To: Evgen Potemkin <evgent@ns.terminal.ru>; +Cc: pgsql-sql
Evgen Potemkin <evgent@ns.terminal.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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2003-01-30 14:56 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-01-25 12:06 Filter function Evgen Potemkin <evgent@ns.terminal.ru>
2003-01-29 08:25 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-01-30 08:27 ` Evgen Potemkin <evgent@ns.terminal.ru>
2003-01-30 14:56 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox