1

Topic: SUBDATE (whether skis do not go, whether I....)

That, I will be short:
SELECT *
FROM ev.public. "DataHolder"
WHERE ts <= (SELECT MAX (ts) FROM ev.public. "DataHolder")
and (ts> = SUBDATE ((SELECT MAX (ts) FROM ev.public. "DataHolder"), INTERVAL 1 HOUR))
ORDER by 1;
The request like not difficult, should not to break, but
ERROR: the ERROR: a syntax error (approximate position: "1")
LINE 4:... LECT MAX (ts) FROM ev.public. "DataHolder"), INTERVAL 1 HOUR))
^
SQL state: 42601
Character: 171
Why 1 it is not pleasant, like all on a manual.... Sometimes in addition on "HOUR" shows, a pier there an error,
Explain, what not so?

2

Re: SUBDATE (whether skis do not go, whether I....)

mayet;
On what such manual?
--
Maxim Boguk
the best support PostgreSQL: dataegret.ru

3

Re: SUBDATE (whether skis do not go, whether I....)

Maxim Boguk wrote:

mayet;
On what such manual?
--
Maxim Boguk
the best support PostgreSQL: dataegret.ru

On a manual for MySQL. The colleague obviously confused a DBMS.