From: Joe Conway <mail@joeconway.com>
To: Thomas Wegner <tomaten@t-online.de>
Cc: pgsql-sql@postgresql.org
Subject: Re: Oracle 'connect by prior' now eaiser in 7.3?
Date: Tue, 14 Oct 2003 10:45:59 -0700
Message-ID: <3F8C3657.7040907@joeconway.com> (raw)
In-Reply-To: <bm5pg1$1819$1@news.hub.org>
References: <B7AD8B4B4A337741B62E633B4827ADD90E2C08@svrexc02.aolau.ops.au.office.aol.com>
<3F6FC51F.6090105@joeconway.com>
<bm1p2g$98o$1@news.hub.org>
<bm5pg1$1819$1@news.hub.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mail@joeconway.com, tomaten@t-online.de
Subject: Re: Oracle 'connect by prior' now eaiser in 7.3?
In-Reply-To: <3F8C3657.7040907@joeconway.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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