[GENERAL] Encoding question when dumping/restoring databases for upgrade

Hello, I am sitting on version 7.4.x and am going to upgrade to version 8.3.x. From all I can read I should have no problem with actual format of the pgdump file (for actual dumping and restoring purposes) but I am having problems with encoding (which I was fairly sure I would). I have search

[GENERAL] String handling function, substring vs. substr

Hi all, I want to call one of the two functions above many times (in an aggregate function) and it says in the manual pages that substr is the same as substring. Does this mean that substr calls substring internally?? Or is it the other way around?? Or are they independent of each other??

Re: [GENERAL] String handling function, substring vs. substr

Hi all, brian <[EMAIL PROTECTED]> writes: [EMAIL PROTECTED] wrote: Does this mean that substr calls substring internally?? Or is it the other way around?? Or are they independent of each other?? Looks like they're pretty evenly matched. Actually, a bit of poking into the contents of pg_p

[GENERAL] Need help with a function from hell..

Hi all, I have a small coding problem where my function is becoming, well, too ugly for comfort. I haven't finished it but you will get picture below. First a small description of the purpose. I have an aggregate function that takes a string and simply concatenates that string to the previou