It would be interesting if the parameters/settings framework could be extended to provide session/table/user/database level custom settings, accessible via the SET/SHOW/RESET commands. Is there anything like this ever been considered/discussed ? Στις Tuesday 11 October 2011 17:06:50 ο/η Eric Radman έγραψε: > When writing unit tests it's sometimes useful to stub functions such as > the current date and time > > -- define mock functions > CREATE OR REPLACE FUNCTION _now() RETURNS timestamp with time zone AS $$ > BEGIN RETURN '2011-10-10 10:00'; END; > $$ LANGUAGE plpgsql; > > -- define tables "accounts" > CREATE TABLE accounts (username varchar, expiration timestamp); > > -- populate with sample data > COPY accounts FROM '/home/eradman/sample_accounts.txt'; > > -- define view "expired_accounts" > CREATE OR REPLACE VIEW expired_accounts AS SELECT * FROM accounts WHERE expiration < _now(); > > -- test views > SELECT assert(0, (SELECT count(*) FROM expired_accounts)::integer); > > Is it possible to declare a global variable that can be referenced from > the user-defined function _now()? I'm looking for a means of abstraction > that allows me to avoid issuing CREATE OR REPLACE FUNCTION ... before > each assert() > > current_time := '2012-01-01'::timestamp > SELECT assert(5, (SELECT count(*) FROM expired_accounts)::integer); > > -- > Eric Radman | http://eradman.com > -- Achilleas Mantzios -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
