Re: Global Variables?

Поиск
Список
Период
Сортировка
От Achilleas Mantzios
Тема Re: Global Variables?
Дата
Msg-id 201110111808.59791.achill@matrix.gatewaynet.com
обсуждение исходный текст
Ответ на Global Variables?  (Eric Radman <ericshane@eradman.com>)
Список pgsql-general
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

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

Предыдущее
От: Sandro Santilli
Дата:
Сообщение: Re: [postgis-users] Query slow down, never completes
Следующее
От: Andreas Forø Tollefsen
Дата:
Сообщение: Re: [postgis-users] Query slow down, never completes