catch SELECT statement return

Поиск
Список
Период
Сортировка
От sconeek@gmail.com
Тема catch SELECT statement return
Дата
Msg-id 1142292486.663232.58990@e56g2000cwe.googlegroups.com
обсуждение исходный текст
Ответы Re: catch SELECT statement return  (Chris <dmagick@gmail.com>)
Список pgsql-general
hi all,
i am working on this postgresql statement. it picks up all non-null
values only. is there a way to pickup all hour values (if any hour
value not existing, still find them and assign their value to be 0).
coz my table does not contain all hour values, only ones which have a
non-zero value.

SELECT to_timestamp(to_char (last_edit_timestamp,'YYYY-MM-DD
HH24:00:00'), 'YYYY-MM-DD HH24:00:00')AS edit_time, count(to_char
(last_edit_timestamp,'YYYY-MM-DD HH24:00:00'))
as edit_time_count FROM dbpt_containerlog GROUP BY to_char
(last_edit_timestamp,'YYYY-MM-DD HH24:00:00') ORDER BY to_char
(last_edit_timestamp,'YYYY-MM-DD HH24:00:00');

please help me, all help appreciated. thanks


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

Предыдущее
От: Chris Travers
Дата:
Сообщение: PostgreSQL on Windows not starting
Следующее
От: "jia ding"
Дата:
Сообщение: \copy combine with SELECT