Date: Mon, 05 Feb 2007 17:02:21 +0100
From: sneumann <sneumann@ipb-halle.de>
Subject: PL/pgsql declaration of string / bit / number with given	(variable!)
	length
To: pgsql-sql@postgresql.org
Message-id: <1170691341.14733.147.camel@lathan.ipb-sub.ipb-halle.de>
Organization: IPB Halle
MIME-version: 1.0
Content-type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="=-DKljXHgx4Q6dG10IF7Uz"


--=-DKljXHgx4Q6dG10IF7Uz
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

Hi,

I have a PL/pgsql function that creates a certain bit string
based on the parameters. Things work fine if I use bit(10)
throughout the function. Now I'd like to return a bit string=20
with the given size "len", but that breaks with a syntax error:

        ret :=3D B'0'::bit(len);
	LINE 1: SELECT  B'0'::bit( $1 )
	                           ^

Any suggestion how to return a (bit) string=20
of user-defined length ?

Thanks in advance,
Yours,
Steffen

CREATE OR REPLACE FUNCTION unarystr(
    value integer,
    len integer
) RETURNS bit(10) AS $$
DECLARE
    ret bit(10);
    one bit(10);
BEGIN
    ret :=3D B'0'::bit(10);
    one :=3D B'1'::bit(10);

    FOR num IN 0..value-1 LOOP
       ret :=3D ret | (one >>num);
    END LOOP;
    RETURN ret;
END;
$$ LANGUAGE plpgsql;


--=20
IPB Halle                    AG Massenspektrometrie & Bioinformatik
Dr. Steffen Neumann          http://www.IPB-Halle.DE
Weinberg 3                   http://msbi.bic-gh.de
06120 Halle                  New phone number !
                             Tel. +49 (0) 345 5582 - 1470
                                  +49 (0) 345 5582 - 0
sneumann(at)IPB-Halle.DE     Fax. +49 (0) 345 5582 - 1409


--=-DKljXHgx4Q6dG10IF7Uz
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)

iD8DBQBFx1UNir2msrPI0lQRAs6TAJwL7jXtQyD7qXV/pHIr7Z+RVGQ9QgCcD8kk
19m1jV5OnjvML889bfJo3kc=
=hJG2
-----END PGP SIGNATURE-----

--=-DKljXHgx4Q6dG10IF7Uz--