setting time zone in a function

Поиск
Список
Период
Сортировка
От Steve Rogerson
Тема setting time zone in a function
Дата
Msg-id 5718B30D.4050103@yewtc.demon.co.uk
обсуждение исходный текст
Ответы Re: setting time zone in a function  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I want the time zone if a function  a bit like ...

CREATE OR REPLACE FUNCTION
   short_name (timestamp with time zone, varchar) RETURNS varchar  AS $$
    DECLARE
        ...
    BEGIN
        SET LOCAL TIME ZONE $2;
        SELECT to_char($1, 'TZ')::varchar
        ...
    END $$
LANGUAGE 'plpgsql' VOLATILE;


But as written is doesn't compile complaining about the "naked" $2. If I quote
the $2 it sets the time zone to $2 literally (I didn't know you could do that,
but that's another issue). Escaping the quotes either as \' or '' doesn't compile.

Help.


Steve


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

Предыдущее
От: Bráulio Bhavamitra
Дата:
Сообщение: Columnar store as default for PostgreSQL 10?
Следующее
От: Francisco Olarte
Дата:
Сообщение: Re: Columnar store as default for PostgreSQL 10?