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

Re: SQL query --- big question???

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Andrei Bintintan" <klodoma(at)ar-sd(dot)net>,<pgsql-sql(at)postgresql(dot)org>
Subject: Re: SQL query --- big question???
Date: 2004-03-12 15:20:19
Message-ID: 200403121520.19774.dev@archonet.com (view raw or flat)
Thread:
Lists: pgsql-sql
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

In response to

pgsql-sql by date

Next:From: tomgDate: 2004-03-12 19:58:12
Subject: pg_dump backwards compat issues
Previous:From: Jeff EckermannDate: 2004-03-12 14:55:53
Subject: Re: sqlloader features

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