Re: connectby for BYTEA keys

From: David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: connectby for BYTEA keys
Date: 2004-02-08 18:30:44
Message-ID: 40268054.2080101@zara.6.isreserved.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-02-08 19:02:26 Re: fsync = true beneficial on ext3?
Previous Message elein 2004-02-08 18:13:47 Re: Fwd: Favorite DB poll on ORA

Browse pgsql-patches by date

  From Date Subject
Next Message Andrew Dunstan 2004-02-08 20:14:11 Re: [HACKERS] dollar quoting
Previous Message Joe Conway 2004-02-08 15:53:14 Re: connectby for BYTEA keys