I am building a text email from data in a database table and then delivering it from the database.
My question is how do I represent a carriage return or line feed in a plpgsql function? I am concatenating the different parts together, but I need to separate out certain sections with carriage returns.
Any help would be appreciated.
pgsql-novice by date
|Next:||From: Michael Fuhr||Date: 2005-03-08 21:29:48|
|Subject: Re: lfcr with plpgsql|
|Previous:||From: Bruno Wolff III||Date: 2005-03-08 17:54:03|
|Subject: Re: Getting started - Interfacing questions|