On 12 February 2012 18:49, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Thom Brown <thom@xxxxxxxxx> writes: >> What am I missing? > > I might be more confused than you, but I think you're supposing that > the result of ascii(E'\\1') has something to do with the match that > the surrounding regexp_replace function will find, later on when it > gets executed. The actual arguments seen by regexp_replace are > > regression=# select E'Hello & goodbye ',E'([&])','&#' || > ascii(E'\\1') || E';\\1'; > ?column? | ?column? | ?column? > ------------------+----------+---------- > Hello & goodbye | ([&]) | \\1 > (1 row) > > and given that, the result looks perfectly fine to me. > > If there's a bug here, it's that ascii() ignores additional bytes in its > input instead of throwing an error for a string with more than one > character. But I believe we've discussed that in the past and decided > not to change it. Okay, in that case I made the wrong assumptions about order of resolution. Thanks -- Thom -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
