X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 97BC3D1BA8F for ; Tue, 20 Apr 2004 22:10:48 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 97156-05 for ; Tue, 20 Apr 2004 22:10:49 -0300 (ADT) Received: from biglumber.com (biglumber.com [207.228.252.42]) by svr1.postgresql.org (Postfix) with SMTP id A85BBD1B49B for ; Tue, 20 Apr 2004 22:10:46 -0300 (ADT) Received: (qmail 3338 invoked from network); 21 Apr 2004 01:10:48 -0000 Received: from unknown (HELO localhost) (207.228.252.42) by 0 with SMTP; 21 Apr 2004 01:10:48 -0000 From: "Greg Sabino Mullane" To: pgsql-admin@postgresql.org Subject: Re: self defined counter function X-PGP-Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 In-Reply-To: <1574570229.20040420095643@radax.net> Date: Wed, 21 Apr 2004 01:10:48 -0000 X-Mailer: JoyMail 1.47 Message-ID: X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200404/270 X-Sequence-Number: 13243 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 (1679616 is 36^4, 36 is 0-9+A-Z) CREATE SEQUENCE abase MINVALUE 0 MAXVALUE 1679616 CYCLE; CREATE OR REPLACE FUNCTION fillbase(BIGINT,INT,INT) RETURNS VARCHAR AS ' DECLARE mynum INTEGER; mybase ALIAS FOR $2; myplaces SMALLINT; first INTEGER; divvy BIGINT; pop VARCHAR := \'\'; BEGIN mynum := $1; myplaces := $3; - -- Max we can do SELECT pow(mybase,myplaces)-1 INTO divvy; IF (mynum > divvy) THEN RAISE EXCEPTION \'The maximum number for base % and % digits is %\', mybase,myplaces,divvy; END IF; LOOP myplaces := myplaces - 1; EXIT WHEN myplaces < 0; SELECT pow(mybase,myplaces) INTO divvy; SELECT mynum/divvy INTO first; SELECT pop || CASE WHEN first < 10 THEN first::text ELSE CHR(55+first) END INTO pop; SELECT mynum%divvy INTO mynum; END LOOP; RETURN pop; END; ' LANGUAGE PLPGSQL IMMUTABLE; CREATE OR REPLACE FUNCTION fourbase(BIGINT) RETURNS VARCHAR AS ' SELECT fillbase($1,36,4); ' LANGUAGE SQL; SELECT fillbase(1234,16,4); SELECT fillbase(1234,36,4); SELECT fourbase(123); SELECT fourbase(nextval('abase')); - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200404202107 -----BEGIN PGP SIGNATURE----- iD8DBQFAhcpovJuQZxSWSsgRApjkAJ93vJnvVbaK5OyZz/dsia/BE+QcuACg6xJi YRwBknjImezEs6fxGpdlY20= =j5K8 -----END PGP SIGNATURE-----