When I created a view in pgAdmin II using a SELECT statement that includes an ORDER BY clause, pgAdmin seemed to ignore that clause. The generated SQL shown with the view properties clearly does not have that clause, even though the original SQL as shown in the description area does have that clause. The same view definition works fine when I create it directly in psql.
Why does pgAdmin translate the view definition SELECT statement into a different form, rather than using it verbatim? This is happening in version 1.1 build 26. -- Fred Yankowski [EMAIL PROTECTED] tel: +1.630.879.1312 Principal Consultant www.OntoSys.com fax: +1.630.879.1370 OntoSys, Inc 38W242 Deerpath Rd, Batavia, IL 60510, USA
