Re: SQL Bug - Mailing list pgsql-bugs

From Heikki Linnakangas
Subject Re: SQL Bug
Date
Msg-id 726e0ba0-67a7-a1a1-4844-8bff8597e00b@iki.fi
Whole thread Raw
In response to Re: SQL Bug  (Bujji Babu <bujji.babu@heales.com>)
Responses Re: SQL Bug
List pgsql-bugs
On 10/06/2016 01:59 PM, Bujji Babu wrote:
> Dear Heikki,
>
> Still same error msg.
>
> select * from connectby('emp','empid','mgrid','1','0')
> AS t(keyid text, parent_keyid text, level int);

That's not what I typed. The keyid and parent_keyid columns need to be 
integers, not text, like in the table.

- Heikki




pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #14356: "FATAL: the database system is starting up" error occurs to queries after PostgreSQL server start
Next
From: Bujji Babu
Date:
Subject: Re: SQL Bug