Этот баннер — требование Роскомнадзора для исполнения 152 ФЗ.
«На сайте осуществляется обработка файлов cookie, необходимых для работы сайта, а также для анализа использования сайта и улучшения предоставляемых сервисов с использованием метрической программы Яндекс.Метрика. Продолжая использовать сайт, вы даёте согласие с использованием данных технологий».
Политика конфиденциальности
|
|
|
Формирование вьювера
|
|||
|---|---|---|---|
|
#18+
Подскажите пожалуйста! Не могу найти ошибку в данном коде пишет - ERROR: syntax error at or near "WHERE" at character 3673 Перепробовал все..... CREATE OR REPLACE VIEW "public"."egw_tracker_view" ( tr_id, tr_summary, tr_tracker, tr_version, tr_status, tr_description, tr_assigned, tr_private, eng_family, tr_budget, tr_completion, tr_creator, tr_created, tr_modifier, tr_modified, tr_closed, tr_priority, tr_resolution, tr_cc, reaction_time, generator_time, second_full_time, second_generator_time) AS SELECT qaz.tr_id, qaz.tr_summary, qaz.tr_tracker, CASE qaz.tr_version WHEN 77 THEN 'Гарантийный'::text WHEN 78 THEN 'Негарантийный'::text WHEN 83 THEN 'Внешнее электоропитание'::text WHEN 90 THEN 'Питание постоянного тока'::text ELSE NULL::text END AS tr_version, CASE qaz.tr_status WHEN -100 THEN 'Открытые'::text WHEN -101 THEN 'Закрытые'::text ELSE 'other'::text END AS tr_status, qaz.tr_description, CASE qaz.tr_assigned WHEN -17 THEN 'Дежурная смена - Восток'::text WHEN -18 THEN 'Дежурная смена - Центр'::text WHEN -19 THEN 'Дежурная смена - Запад'::text ELSE NULL::text END AS tr_assigned, date(('1970-01-01 00:00:00'::timestamp without time zone + ((qaz.tr_created)::double precision * '00:00:01'::interval))) AS tr_private, (((qaz3.n_family)::text || ' '::text) || (qaz3.n_given)::text) AS eng_family, date(('1970-01-01 00:00:00'::timestamp without time zone + ((qaz.tr_closed)::double precision * '00:00:01'::interval))) AS tr_budget, qaz.res_id AS tr_completion, qaz.name AS tr_creator, qaz1.name AS tr_created, (((edc.n_family)::text || ' '::text) || (edc.n_given)::text) AS tr_modifier, b4.reply_message AS tr_modified, (((qaz.tr_closed - qaz.tr_created))::double precision * '00:00:01'::interval) AS tr_closed, ('1970-01-01 00:00:00'::timestamp without time zone + ((qaz.tr_created)::double precision * '00:00:01'::interval)) AS tr_priority, ('1970-01-01 00:00:00'::timestamp without time zone + ((qaz.tr_closed)::double precision * '00:00:01'::interval)) AS tr_resolution, ('1970-01-01 00:00:00'::timestamp without time zone + ((b4.reply_created)::double precision * '00:00:01'::interval)) AS tr_cc, (((b4.reply_created - qaz.tr_created))::double precision * '00:00:01'::interval) AS reaction_time, (((qaz.tr_closed - b4.reply_created))::double precision * '00:00:01'::interval) AS generator_time, (qaz.tr_closed - qaz.tr_created) AS second_full_time, (qaz.tr_closed - b4.reply_created) AS second_generator_time FROM (( ((egw_tracker a JOIN egw_links b ON (((a.tr_id)::text = (b.link_id1)::text))) JOIN egw_resources c ON (((((c.res_id)::text = (b.link_id2)::text) AND ((b.link_app2)::text = 'resources'::text)) AND ((b.link_app1)::text = 'tracker'::text)))) JOIN egw_categories e ON (((e.cat_id = c.cat_id) AND ((e.cat_name)::text = 'Генераторы переменного тока'::text))))) qaz, (((egw_tracker a1 JOIN egw_links b1 ON (((a1.tr_id)::text = (b1.link_id1)::text))) JOIN egw_resources c1 ON (((((c1.res_id)::text = (b1.link_id2)::text) AND ((b1.link_app2)::text = 'resources'::text)) AND ((b1.link_app1)::text = 'tracker'::text)))) JOIN egw_categories e1 ON (((e1.cat_id = c1.cat_id) AND ((e1.cat_name)::text <> 'Генераторы переменного тока'::text)))) qaz1, (egw_tracker aaa JOIN egw_addressbook ccc ON ((ccc.account_id = aaa.tr_creator))) edc, ((egw_tracker a3 JOIN egw_links b3 ON ((((a3.tr_id)::text = (b3.link_id1)::text) AND ((b3.link_app1)::text = 'tracker'::text)))) JOIN egw_addressbook c3 ON ((((c3.contact_id)::text = (b3.link_id2)::text) AND ((b3.link_app2)::text = 'addressbook'::text)))) qaz3, (egw_tracker a4 JOIN egw_tracker_replies b4 ON (((a4.tr_id = b4.tr_id) AND (((b4.reply_message = 'Бригада прибыла на объект, запустили генератор.'::text) OR ("substring"(b4.reply_message, 1, 9) = 'По дороге'::text)) OR ("substring"(b4.reply_message, 1, 24) = 'Генератор не запускался.'::text)))) WHERE ((qaz.tr_id = edc.tr_id) AND (qaz.tr_id = qaz1.tr_id) AND (qaz.tr_id = qaz3.tr_id) AND (qaz.tr_id = a4.tr_id)); ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 21.05.2008, 18:35 |
|
||
|
|

start [/forum/topic.php?fid=53&fpage=269&tid=2004345]: |
0ms |
get settings: |
9ms |
get forum list: |
15ms |
check forum access: |
2ms |
check topic access: |
2ms |
track hit: |
37ms |
get topic data: |
7ms |
get forum data: |
3ms |
get page messages: |
23ms |
get tp. blocked users: |
1ms |
| others: | 219ms |
| total: | 318ms |

| 0 / 0 |
