X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3B5A3D1B540 for ; Tue, 14 Oct 2003 17:48:23 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 52009-08 for ; Tue, 14 Oct 2003 14:47:53 -0300 (ADT) Received: from joeconway.com (66-146-172-86.skyriver.net [66.146.172.86]) by svr1.postgresql.org (Postfix) with ESMTP id 48DCFD1B52F for ; Tue, 14 Oct 2003 14:47:48 -0300 (ADT) Received: from [206.19.64.3] (account jconway HELO joeconway.com) by joeconway.com (CommuniGate Pro SMTP 4.1.5) with ESMTP-TLS id 426523; Tue, 14 Oct 2003 10:46:45 -0700 Message-ID: <3F8C3657.7040907@joeconway.com> Date: Tue, 14 Oct 2003 10:45:59 -0700 From: Joe Conway User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.3) Gecko/20030312 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Thomas Wegner Cc: pgsql-sql@postgresql.org Subject: Re: Oracle 'connect by prior' now eaiser in 7.3? References: <3F6FC51F.6090105@joeconway.com> In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/160 X-Sequence-Number: 15560 Thomas Wegner wrote: >>SELECT "ID_WINUSER" FROM connectby('"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 Please see the documentation (README.tablefunc). You need to properly specify the column definitions in the FROM clause, i.e. (untested): SELECT "ID_WINUSER" FROM connectby('"WINUSER"', '"ID_WINUSER"','"REF_ID_WINUSER"', 4, 0, '~') AS t("ID_WINUSER" integer, "REF_ID_WINUSER" integer, level integer, branch text); HTH, Joe