Re: connectby for BYTEA keys - Mailing list pgsql-general

Joe Conway wrote:
> --without patch
> regression=# SELECT * FROM connectby('connectby_bytea', 'keyid',
> 'parent_keyid', 'row\\134', 0, '') AS t(keyid bytea, parent_keyid bytea,
> level int, branch text);
> ERROR:  invalid input syntax for type bytea
>
> --with attached patch
> regression=# SELECT * FROM connectby('connectby_bytea', 'keyid',
> 'parent_keyid', 'row\\134', 0, '') AS t(keyid bytea, parent_keyid bytea,
> level int, branch text);

Joe,

Thanks for the fix.

--
dave