concatenate text

From: Sterpu Victor <victor(at)ambra(dot)ro>
To: pgsql-general(at)postgresql(dot)org
Subject: concatenate text
Date: 2005-09-05 00:00:30
Message-ID: 431B8A9E.6010409@ambra.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Can I do something like this?
SELECT sum(name) FROM table;

Where name is a text field.
I know 'sum' doesn't work, but is there another solution?
'||' is not good because it will take just 2 arguments.

Thank you.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2005-09-05 00:08:07 Re: Query questions
Previous Message Michael Glaesemann 2005-09-04 22:31:24 Re: Upgrading from 7.4 to 8.0.1