Re: [BUGS] Fwd: Bug#249036: postgresql: zero bytes cannot be entered in string literal, not even with \000 notation

Hi! On 2004-05-17 8:37 -0400, Bruce Momjian wrote: > The issue is that bytea needs double-backslashes because single > backslashes are processed by the parser into strings: Indeed. Thank you for this! Martin -- Martin Pitt Debian GNU/Linux Developer [EMAIL PROTECTED]

Re: [BUGS] Fwd: Bug#249036: postgresql: zero bytes cannot be entered

Martin Pitt wrote: > Hi PostgreSQL hackers! > > We recently got the Debian bug report below. Does anybody have an idea about that? > > Thanks and have a nice day! > > if i issue the following query: > $ select decode(encode('\001\000\001'::bytea,'hex'),'hex'); > the result will always be '\001' a

[BUGS] Fwd: Bug#249036: postgresql: zero bytes cannot be entered in string literal, not even with \000 notation

Hi PostgreSQL hackers! We recently got the Debian bug report below. Does anybody have an idea about that? Thanks and have a nice day! Martin - Forwarded message from Peter Schueller <[EMAIL PROTECTED]> - Subject: Bug#249036: postgresql: zero bytes cannot be entered in string litera