t_id=prior id_tree
But how must i use this with "with recursive" function?
Every example i found uses two tables. I have only one!
Please help me! I need this to use my oracle tables with
the same speed in sybase 9.0.
---------
Thomas Wegner
Cabrio Meter
Whera are tablefunc's like connectby in 8.0?
-
Thomas Wegner
Cabrio Meter - The Weather Plugin for Trillian
http://trillian.wegner24.de/cabriometer
---(end of broadcast)---
TIP 2: you can get of
Sorry, i found it. I'm Win32 user and use installation
from pgInstaller. I compile it and it run fine :-) !
-
Thomas Wegner
Cabrio Meter - The Weather Plugin for Trillian
http://trillian.wegner24.de/cabriometer
"Thomas Wegner" &l
."user" FOR EACH ROW
EXECUTE PROCEDURE "public"."user_function"();
CREATE TRIGGER "user_update" BEFORE UPDATE
ON "public"."user" FOR EACH ROW
EXECUTE PROCEDURE "public"."user_function"();
and do a simple
select fro
ype_value
FROM "lists" L, "typecode" T, "adressen" A
WHERE T."id_typecode"=L."lists_type" AND A."id_adressen"=L."firma"
ORDER BY L."id_lists"
--
Thomas Wegner
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
x27;"WINUSER"', '"ID_WINUSER"',
'"REF_ID_WINUSER"', 4, 0, '~') AS t("ID_WINUSER" integer)
and get this error:
ERROR: Query-specified return tuple not valid for Connectby: wrong number
of columns
How is the correct use of
Hello!
Can anyone help me to use connectby() with my structure?
I cannot change the name of tables. It is a import!
--
Thomas Wegner
"Thomas Wegner" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
news:[EMAIL PROTECTED]
> Hello,
>
>
