Re: [GENERAL] concatenate text

2005-09-05 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 an

[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:

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 use a

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 an

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