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 по дате отправления: