| From: | Heikki Linnakangas <hlinnaka(at)iki(dot)fi> |
|---|---|
| To: | Bujji Babu <bujji(dot)babu(at)heales(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: SQL Bug |
| Date: | 2016-10-06 11:07:27 |
| Message-ID: | 726e0ba0-67a7-a1a1-4844-8bff8597e00b@iki.fi |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bujji Babu | 2016-10-06 11:19:22 | Re: [BUGS] SQL Bug |
| Previous Message | Heikki Linnakangas | 2016-10-06 11:04:03 | Re: BUG #14356: "FATAL: the database system is starting up" error occurs to queries after PostgreSQL server start |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bujji Babu | 2016-10-06 11:19:22 | Re: [BUGS] SQL Bug |
| Previous Message | Bujji Babu | 2016-10-06 10:59:58 | Re: [BUGS] SQL Bug |