Skip site navigation (1) Skip section navigation (2)

'order by' clause lost when creating view

From: fred(at)ontosys(dot)com
To: pgadmin-support(at)postgresql(dot)org
Subject: 'order by' clause lost when creating view
Date: 2001-08-28 12:16:37
Message-ID: 20010828071637.A29136@ontosys.com (view raw or flat)
Thread:
Lists: pgadmin-support
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           fred(at)OntoSys(dot)com      tel: +1.630.879.1312
Principal Consultant     www.OntoSys.com       fax: +1.630.879.1370
OntoSys, Inc             38W242 Deerpath Rd, Batavia, IL 60510, USA

pgadmin-support by date

Next:From: dpageDate: 2001-08-28 19:17:00
Subject: RE: 'order by' clause lost when creating view
Previous:From: fredDate: 2001-08-27 20:23:59
Subject: does pgAdmin II create any server objects?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group