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@gmx.net       http://yi.org/peter-e/