X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B3925D1D168 for ; Fri, 12 Mar 2004 15:20:38 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 52703-02 for ; Fri, 12 Mar 2004 11:20:40 -0400 (AST) Received: from anchor-post-37.mail.demon.net (anchor-post-36.mail.demon.net [194.217.242.86]) by svr1.postgresql.org (Postfix) with ESMTP id 741BFD1CCD7 for ; Fri, 12 Mar 2004 11:20:36 -0400 (AST) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-37.mail.demon.net with esmtp (Exim 3.35 #1) id 1B1oSk-000FoX-0b; Fri, 12 Mar 2004 15:20:40 +0000 Received: by mainbox.archonet.com (Postfix, from userid 529) id 8F32A1627B; Fri, 12 Mar 2004 15:20:19 +0000 (GMT) Received: from client17.archonet.com (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 609E315A83; Fri, 12 Mar 2004 15:20:17 +0000 (GMT) From: Richard Huxton To: "Andrei Bintintan" , Subject: Re: SQL query --- big question??? Date: Fri, 12 Mar 2004 15:20:19 +0000 User-Agent: KMail/1.5 References: <007e01c4083f$5fb78100$0b00a8c0@forge> In-Reply-To: <007e01c4083f$5fb78100$0b00a8c0@forge> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200403121520.19774.dev@archonet.com> X-Bogosity: No, tests=bogofilter, spamicity=0.000000, version=0.15.3 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/150 X-Sequence-Number: 17249 On Friday 12 March 2004 14:36, Andrei Bintintan wrote: > Hi to all, > > I have a big question. > > Can I write a query/function/agregate function (whatever) so that I can > return the result of a query in a single line? I don't know if this is > possible to be made and please if it is not possible please say. You're best doing this in the application really. However, if you only want to work with text, search the mailing list archives using keywords like: text concat aggregate and you should see an example solution where you build your own aggregate function. -- Richard Huxton Archonet Ltd