Function Question - Mailing list pgsql-general

From Jake Stride
Subject Function Question
Date
Msg-id CABO-GFSNxsK0T756EPdXVa3cH8W_tx_j0b8CSfZONt=h+=gHhw@mail.gmail.com
Whole thread Raw
Responses Re: Function Question
List pgsql-general
I am trying to create a function that gets fired when a new row is
inserted. I can get the following function built but my problem is
that the sequence that is created is called "NEW.key" rather than the
value that is being inserted (it should be a UUID).

I have tried putting the key into a variable and using no quotes but
it either errors or gives me "NEW.key" rather than "whatever-uuid-was
inserted".

Please can anybody give me some pointers?

Thanks
Jake

CREATE OR REPLACE FUNCTION public.setup_sequence()
                RETURNS trigger
                LANGUAGE plpgsql
                AS $$
                    DECLARE
                        sequence_name UUID;
                    BEGIN
                        IF (
                            TG_OP = 'INSERT' AND
                            NEW.type = 'auto_increment'
                        ) THEN
                            SELECT NEW.key INTO STRICT sequence_name;
                            -- Set up the sequence
                            CREATE SEQUENCE \"NEW.key\";
                            -- Set the start value
                            --SELECT SETVAL(sequence_name, NEW.auto_increment_default);
                        END IF;
                        RETURN NEW;
                    END;

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re:
Next
From: Rodger Donaldson
Date:
Subject: Re: Hope for a new PostgreSQL era?