Pb de 'MAX'

[grellierj]

bJour,
je n'arrive pas à faire le MAX sur les dates revoyé par cette requete,je ne comprend pas pourquoi il ne fonctionne pas ! :
je travail sous postgresql.

Code :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
 
SELECT '217.15.90.30' AS ip,login, datemax, timemax, req1.pppd
FROM
(SELECT MAX(date) AS datemax,time AS timemax,msg,substr(msg,position('pppd' IN msg),position(':' IN msg) - position('pppd'IN msg)) AS pppd 
FROM logs
GROUP BY time,msg) AS req1,
(SELECT REPLACE(substr(msg,position('for' IN msg),position('@' IN msg) - position('CHAP peer authentication succeeded for' IN msg)),'for',' ') AS login,
substr(msg,position('pppd' IN msg),position(':' IN msg) - position('pppd'IN msg)) AS pppd
FROM logs
WHERE msg LIKE '%peer authentication succeeded%'
GROUP BY login,pppd) AS req2
WHERE req1.pppd = req2.pppd  
AND msg LIKE '%IPCP ConfAck id=%' 
AND msg LIKE '%ddr%' AND msg LIKE '%217.15.90.30%' 
AND msg LIKE '%sent%'
AND '217.15.90.30'= substr(msg,position('217.15.90.30' IN msg),position('>' IN msg) - position('217.15.90.30' IN msg))
ORDER BY datemax, timemax 
DESC

[Médiat]

Envoyé par grellierj

je ne comprend pas pourquoi il ne fonctionne pas

Moi non plus

Lire les règles du forum, il n'y a pas de devins ici