Ralf Miller writes:
> CREATE TABLE test (a BIT(3), b BIT VARYING(5));
> INSERT INTO test VALUES (B'101', B'00'); ### try: ..VALUES
> (B'101', 'B00') instead of: ..VALUES (B'101', B'00')
> SELECT SUBSTRING(b FROM 1 FOR 2) FROM test;
Why?
--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/