Referring to function parameter in function

Поиск
Список
Период
Сортировка
От Thom Brown
Тема Referring to function parameter in function
Дата
Msg-id AANLkTi=aF5XpYz+2cpN77OViM46oGez79+awQ5PnzaTx@mail.gmail.com
обсуждение исходный текст
Ответы Re: Referring to function parameter in function  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I appear to be having a problem with a function I've created, and no
doubt it'll be something obvious I'm doing wrong.  Here's my function:

CREATE OR REPLACE FUNCTION get_lsfr(
    bitlength INT,
    taps INT[],
    from_value INT
) RETURNS INT AS $$
DECLARE
    last_tap_value BIT;
    tap INT;
    new_value INT;
BEGIN
    IF (SELECT MAX(x) FROM unnest(taps) AS x) > bitlength THEN
        RAISE EXCEPTION 'LSFR tap exceeds range of value.';
    END IF;

    FOR tap IN SELECT value FROM unnest(taps) AS x(value) ORDER BY value DESC LOOP
        IF last_tap_value IS NOT NULL THEN
            last_tap_value := last_tap_value #
GET_BIT(from_value::bit(bitlength), tap.value-1);
        ELSE
            last_tap_value := GET_BIT(from_value::bit(bitlength), tap.value-1);
            CONTINUE;
        END IF;
    END LOOP;

    new_value := (last_tap_value || SUBSTRING(from_value::BIT(bitlength),
1, bitlength - 1))::BIT(bitlength)::INT;

    RETURN new_value;
END;
$$ LANGUAGE plpgsql;

And here's it's usage and result:

select get_lsfr(4,'{3,4}'::int[],6);
ERROR:  invalid input syntax for integer: "bitlength"
LINE 1: SELECT GET_BIT(from_value::bit(bitlength), tap.value-1)
                                   ^
QUERY:  SELECT GET_BIT(from_value::bit(bitlength), tap.value-1)
CONTEXT:  PL/pgSQL function "get_lsfr" line 14 at assignment

If the function is difficult to read, please look at this paste:
http://pgsql.privatepaste.com/fd5b83166c

I want to use the parameter called "bitlength" as the length of a bit
when casting a value.

So, in this case, it would be GET_BIT(6::bit(4), 4-1)

What am I missing?

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

В списке pgsql-general по дате отправления:

Предыдущее
От: John DeSoi
Дата:
Сообщение: Re: Need magic for identifieing double adresses
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Referring to function parameter in function