Re: lfcr with plpgsql - Mailing list pgsql-novice

From Derrick Betts
Subject Re: lfcr with plpgsql
Date
Msg-id 1c5001c5242b$e93c6450$0200a8c0@main
Whole thread Raw
In response to lfcr with plpgsql  ("Derrick Betts" <derrick@grifflink.com>)
Responses Re: lfcr with plpgsql
List pgsql-novice
It doesn't seem to be working that way, however.  This is the code that
writes the string:

Body := \'Hello \'||agentnm||\',\n\';
  Body := Body || \'This is a reminder for you to make contact with
\'||fname||\' \'||lname||\'.\n\';
  Body := Body || \'The time to make contact was \'||remtime||\'\n\n\';
  Body := Body || \'Thanks,\n\';
  Body := Body || \'The reminder system\';

And this is the result in the email that I receive:

Hello Derrick Betts, This is a reminder for you to make contact with Tom
Jones. The time to make contact was 2005-03-09 13:25:00 Thanks, The reminder
system

Any thoughts?
Thanks,
Derrick


----- Original Message -----
From: "Michael Fuhr" <mike@fuhr.org>
To: "Derrick Betts" <derrick@grifflink.com>
Cc: <pgsql-novice@postgresql.org>
Sent: Tuesday, March 08, 2005 2:29 PM
Subject: Re: [NOVICE] lfcr with plpgsql


> On Tue, Mar 08, 2005 at 12:36:16PM -0700, Derrick Betts wrote:
>
>> My question is how do I represent a carriage return or line feed
>> in a plpgsql function?
>
> See "String Constants" in the "SQL Syntax" chapter of the documentation.
> Here's a link to the latest version:
>
> http://www.postgresql.org/docs/8.0/interactive/sql-syntax.html#SQL-SYNTAX-STRINGS
>
> --
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>



pgsql-novice by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: lfcr with plpgsql
Next
From: Michael Fuhr
Date:
Subject: Re: lfcr with plpgsql