Table aliases in delete statements?

Hi All,

Is there any reason for not allowing table aliases in
delete statements?

I was trying to delete duplicates from an ascend log
database when I hit the following "parse" error.

(Perhaps I shouldn't be using a correlated subquery!!)

Simplified example follows.....

emkxp01=> create table deltest ( sessionid int, respdate datetime );
CREATE
emkxp01=> insert into deltest values ( 1, now() );
INSERT 58395 1
emkxp01=> insert into deltest values ( 1, now() );
INSERT 58396 1
emkxp01=> insert into deltest values ( 2, now() );
INSERT 58397 1
emkxp01=> insert into deltest values ( 2, now() );
INSERT 58398 1
emkxp01=> select * from deltest s1 where s1.respdate not in ( select
min(s2.respdate) from deltest s2 where s1.sessionid = s2.sessionid);
sessionid | respdate
-----------+------------------------------
1 | Tue 07 Dec 22:32:08 1999 GMT
2 | Tue 07 Dec 22:32:19 1999 GMT
(2 rows)

emkxp01=> select * from deltest;
sessionid | respdate
-----------+------------------------------
1 | Tue 07 Dec 22:32:01 1999 GMT
1 | Tue 07 Dec 22:32:08 1999 GMT
2 | Tue 07 Dec 22:32:14 1999 GMT
2 | Tue 07 Dec 22:32:19 1999 GMT
(4 rows)

emkxp01=> delete from deltest s1 where s1.respdate not in ( select
min(s2.respdate) from deltest s2 where s1.sessionid = s2.sessionid);
ERROR: parser: parse error at or near "s1"
emkxp01=>