Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7D2992E003D for ; Wed, 30 Jan 2008 06:42:34 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 08739-10 for ; Wed, 30 Jan 2008 06:42:29 -0400 (AST) Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.174]) by postgresql.org (Postfix) with ESMTP id 918842E0062 for ; Wed, 30 Jan 2008 06:42:29 -0400 (AST) Received: from webserv.wug.de ([194.25.154.138]) by mrelayeu.kundenserver.de (node=mrelayeu8) with ESMTP (Nemesis) id 0ML31I-1JKAOh3DI3-0002qa; Wed, 30 Jan 2008 11:42:28 +0100 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1JKAOg-0000sO-00 for pgsql-sql@postgresql.org; Wed, 30 Jan 2008 11:42:26 +0100 Date: Wed, 30 Jan 2008 11:42:26 +0100 From: "A. Kretschmer" To: pgsql-sql@postgresql.org Subject: Re: Sql ORDER BY and ASC/DESC question Message-ID: <20080130104226.GF26490@a-kretschmer.de> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-OS: Debian/GNU Linux - weil ich es mir Wert bin! User-Agent: Mutt/1.5.9i X-Provags-ID: V01U2FsdGVkX1/WTng7GZ7s1f40zX2xeBgfVkOws4T9AQdq/k8 Iy5cwYEb3xt6+huBKR/nYFDSDEHAJoBc4Bz0/as5JJsbnAOlfU NCZDBZLoRVwOZkj96fZtzQetbTAElon X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/227 X-Sequence-Number: 30080 am Wed, dem 30.01.2008, um 11:35:51 +0100 mailte Jaroslav Sivy folgendes: > Hello everyone, > > I have following problem: am using pl/sql functions to trigger some > sql code and i need to pass ORDER_BY column name and ASC/DESC sorting > order as an input parameters into that function and order the result > based on these input parameters. > > The problem is, that the only way is to create query as "string" and > then execute it as "string". Right. > > Is there any other way around how to avoid that "string query"? No. > If it's not possible, could anyone implement this feature into one of > future versions? I think that it would be quite handy to have Unlikely... Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net