Received: from mail.utexas.edu (wb3-a.mail.utexas.edu [128.83.126.138]) by postgresql.org (8.11.3/8.11.1) with SMTP id f6FK1ha03710 for ; Sun, 15 Jul 2001 16:01:43 -0400 (EDT) (envelope-from webmaster@robbyslaughter.com) Received: (qmail 19813 invoked by uid 0); 15 Jul 2001 20:01:41 -0000 Received: from adsl-64-218-163-131.dsl.austtx.swbell.net (HELO robmanbox) (64.218.163.131) by umbs-smtp-3 with SMTP; 15 Jul 2001 20:01:41 -0000 Reply-To: From: "Robby Slaughter" To: "Josh Berkus" , "Peter Eisentraut" Cc: Subject: RE: Hey! ORDER BY in VIEWS? Date: Sun, 15 Jul 2001 15:02:43 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-Mimeole: Produced By Microsoft MimeOLE V5.50.4133.2400 Importance: Normal In-Reply-To: X-Archive-Number: 200107/188 X-Sequence-Number: 3983 Josh: You wondered: >What happens if I put an ORDER BY in a view, then call an ORDER BY in a >query, e.g.: > >CREATE VIEW test_view AS >SELECT client_name, city, zip FROM clients >WHERE zip IS NOT NULL >ORDER BY zip; > >SELECT * FROM test_view ORDER BY city; > >Does the second ORDER BY override or suppliment the view ORDER BY, or is >it ignored? I think this question falls into the "Don't ask, don't tell" category of computer related questions. I can't think of a reason to design this way, the behavior isn't specified or sensible, so just don't do it! Sorry if I'm over-admonishing. Curiosity killed the cat. -Robby