On Thu, Jan 7, 2010 at 11:05 AM, Leonardo F <m_li...@yahoo.it> wrote: >> Thanks! Please add your patch here: >> >> https://commitfest.postgresql.org/action/commitfest_view/open >> > > > Ok; but what about what I said about the difference between bit/string > substring? > That affects overlay behaviour for bit... > > > I've even got > > "ERROR: invalid memory alloc request size 4244635647" > > with: > > > SELECT substring(B'1111000000000001' from 5 for -2); > > (this is 8.4.2, windows version, not modified...) > > > > test=# SELECT substring(B'1111000000000001' from 1 for -1); > substring > ------------------ > 1111000000000001 > (1 row) > > > test=# SELECT substring('1111000000000001' from 1 for -1); > ERROR: negative substring length not allowed
I haven't tried to reproduce it, but that sounds like a bug. ....Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers