if you need oracle's syntax and can recompile pgsql see patch at
http://gppl.terminal.ru/index.eng.html
regards,
evgen potemkin
---
On Tue, 23 Sep 2003, Merrall, Graeme wrote:
>
> I'll start by admitting that I've not looked at it myself yet but I'm
> just wonder
it's base-7.3.1 from one of the russian mirrors.
regards,
---
.evgen
On Wed, 29 Jan 2003, Tom Lane wrote:
> Evgen Potemkin <[EMAIL PROTECTED]> writes:
> > term2=>select * from tab where tab=1;
> > ERROR: exprType: Do not know how to get type for 711 node
>
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=>se
Good time of day!
I have two tables
news(newsid int4, newscltid int4 references clt(cltid) match full,newstext text)
and
clt(cltid int4, somedata text).
after clt is renamed , for ex. to clt_old, newscltid start to reference to
clt_old.cltid.
i'm create new table clt(cltid int4, anotherdata
Hi there!
Can anybody explain behavior of ?
Or give a link where explanation can be found?
Or something like that ?:)
To my regret, i can't figure it out
right from SQL standard description with my "brute force".
regards,
---
.evgen
---(end of broadcast)---
-Josh,
i don't be so thrilled:), with current implementation of /contrib/tablefunc
mine problem sill remains: i need to sort tree leaves in some order,
independent of tree itself. this can be fixed (in tablefunc) by addition to
connectby() one more field like 'order_by' or so. but it will be more
Joe,
i've made it already,as send first 'Proposal ...' message,
but found a small bug. within nearest days i'll fix it, and post the patch
to pgsql-patches.
i've described why i can't use connectby() in message to Josh Berkus.
i'll enhance CONNECT BY as clause, but not as function. i think it's m
Oleg,
i've read that info. mine CONNECT BY patch is based on internal pg's query
processing,
from that point it's a kind of ORDER BY or GROUP BY clause. Index access is
implemented by
lower layer.
regards,
---
.evgen
On Sat, 16 Nov 2002, Oleg Bartunov wrote:
> Evgen,
>
> read info about ltr
I was have made a module like ltree, i don't know how you implement it,
but mine doesn't fit.
The problem : for ex. you need to select a tree, but with childs of
each parent is sorted.
in my module i've defined a tree path as set of
numbers separated by dot ('1.234.456.789'::hier for ex.), a compa
Hi there!
I want to propose the patch for adding the hierarchical queries posibility.
It allows to construct queries a la Oracle for ex:
SELECT a,b FROM t CONNECT BY a PRIOR b START WITH cond;
I've seen this type of queries often made by adding a new type, which stores
position of row in the tre
10 matches
Mail list logo
