Re: [SQL] Oracle 'connect by prior' now eaiser in 7.3?

[Joe Conway]

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



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
              http://archives.postgresql.org