[EMAIL PROTECTED] wrote:
insert into table1 values( DEFAULT, B'1'::bit( n ) );
Where n is one of the parameters to the PL/pgSQL function, but that
doesn't work. PostgreSQL doesn't like having a variable for the bit
string length. Does anyone have any ideas how I could achieve this?
Try casting from a string:
SELECT ('1' || repeat('0', n-1))::bit varying;
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-sql
