Hi, Is AS in "SELECT my_column AS my_name FROM my_table" mandatory to be SQL92 compliant?
PostgreSQL requires this keyword by default when defining alias, which might be good thing. I mean, I would prefer being notified from a syntax error than spending a couple of hours wondering why a client application, at the end of a several data marshalling processes, doesn't get the right data... For instance MySQL doesn't require it and sometimes that sucks: SELECT my_column1 my_column2, my_column3 FROM my_table Regards, -- Daniel ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster