[SQL] order function in aggregate

2008-07-30 Thread Michael Toews
Hi, I'm relatively new to object oriented databases and postgres (~ 4 months), so I'm not sure what is wrong with my custom aggregate function. I'm using Postgres 8.3.3 (results are same on Windows and Ubuntu versions). Here is my data required to explain my problem:

Re: [SQL] Insert a space between each character

2008-09-16 Thread Michael Toews
Hi, Use a regular expression, e.g.: select trim(regexp_replace('foobarbaz', '(.)', E'\\1 ', 'g')); See http://www.postgresql.org/docs/8.3/static/functions-matching.html for more. +mt Nicholas I wrote: > Hi, > > can anybody help me, to insert a space between each character in > postgresql. > >