Meaning of "$$"

Поиск
Список
Период
Сортировка
От David Saracini
Тема Meaning of "$$"
Дата
Msg-id 358518.3746.qm@web82901.mail.mud.yahoo.com
обсуждение исходный текст
Ответы Re: Meaning of "$$"
Список pgsql-novice
Hello All,

I can't seem to find any documentation on what the "$$" at the beginning and end of a function.  Obviously, it seems
likea delimiter, but I have seen examples such as where it has a string value between the $.  Why? What does this do?
 I'vedone some searching and reading and can't quit figure it out.   

thanks,

Please see the following for the 8.3 online documentation:

CREATE FUNCTION emp_stamp() RETURNS trigger AS $emp_stamp$ <----note!
    BEGIN
        -- Check that empname and salary are given
        IF NEW.empname IS NULL THEN
            RAISE EXCEPTION 'empname cannot be null';
        END IF;
        IF NEW.salary IS NULL THEN
            RAISE EXCEPTION '% cannot have null salary', NEW.empname;
        END IF;

        -- Who works for us when she must pay for it?
        IF NEW.salary < 0 THEN
            RAISE EXCEPTION '% cannot have a negative salary', NEW.empname;
        END IF;

        -- Remember who changed the payroll when
        NEW.last_date := current_timestamp;
        NEW.last_user := current_user;
        RETURN NEW;
    END;
$emp_stamp$ LANGUAGE plpgsql;

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

Предыдущее
От: David Saracini
Дата:
Сообщение: Re: prevent an update from occurring under certain conditions
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Meaning of "$$"