Re: [GENERAL] concatenate text

2005-09-04 Thread Tino Wildenhain
Am Montag, den 05.09.2005, 03:00 +0300 schrieb Sterpu Victor: > 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. > Yes you can write a

Re: [GENERAL] concatenate text

2005-09-04 Thread Allan Wang
On Sun, 2005-09-04 at 20:37 -0400, Allan Wang wrote: > On Mon, 2005-09-05 at 03:00 +0300, Sterpu Victor wrote: > > Can I do something like this? > > SELECT sum(name) FROM table; > > > > You can add a custom aggregate function that turns your data into an > array, see http://www.postgresql.org/doc

Re: [GENERAL] concatenate text

2005-09-04 Thread Michael Fuhr
On Mon, Sep 05, 2005 at 03:00:30AM +0300, Sterpu Victor wrote: > 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. Are you looking for a

Re: [GENERAL] concatenate text

2005-09-04 Thread David Fetter
On Mon, Sep 05, 2005 at 03:00:30AM +0300, Sterpu Victor wrote: > 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. Currently, you can us

[GENERAL] concatenate text

2005-09-04 Thread Sterpu Victor
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. ---(end of broadcast)--- TIP 4: Hav