Error with a SQL query 'between .. and .. and'

Поиск
Список
Период
Сортировка
От Turbo Fredriksson
Тема Error with a SQL query 'between .. and .. and'
Дата
Msg-id 873czv6wj6.fsf@papadoc.bayour.com
обсуждение исходный текст
Ответы Re: Error with a SQL query 'between .. and .. and'  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
This SQL query works in 7.1.3, but not in 7.2, how come?

select count(*) from log where starttime between now()-interval(60*60) and now() and statuscode='2';
ERROR:  parser: parse error at or near "*"

If I precalculate 60*60, I get this:

select count(*) from log where starttime between now()-interval(3600) and now() and statuscode='2';
ERROR:  parser: parse error at or near "and"


nuclear supercomputer explosion Marxist FBI Iran SEAL Team 6 quiche
Qaddafi nitrate class struggle South Africa counter-intelligence
attack Ortega
[See http://www.aclu.org/echelonwatch/index.html for more about this]


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

Предыдущее
От: Oliver Elphick
Дата:
Сообщение: Re: foreign key is from different tables - what to do?
Следующее
От: Karel Zak
Дата:
Сообщение: Re: elog() proposal