Thread:

When editing a plpgsql function, I enter text strings with \' my string \'
(no success with all kinds of quotes or double quotes).

But when I try to modify the function (not a very skilled programmer ... )
,  backslashes are lost. Is there a mean to not re-type these Backslashes ?

Thanks

___________________________________________
Jacques Massé
Tel. 33 (0)5 57 89 08 11 - Fax 33 (0)5 57 89 08 01

> -----Original Message-----
> From: Masse Jacques [mailto:jacques.masse@bordeaux.cemagref.fr]
> Sent: 11 March 2002 14:44
> To: 'pgadmin-support@postgresql.org'
> Subject: [pgadmin-support]
>
>
> When editing a plpgsql function, I enter text strings with \'
> my string \' (no success with all kinds of quotes or double quotes).
>
> But when I try to modify the function (not a very skilled
> programmer ... ) ,  backslashes are lost. Is there a mean to
> not re-type these Backslashes ?

Hi,

There has been a bug fixed in the current CVS code that handles quoting in
plpgsql functions. Please try the latest snapshot from
http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/binaries/ (just click the
'Download Tarball' link). Installation instructions are in the included
README.txt.

Note, that you should use '' inside functions, not \' - see
http://www.postgresql.org/idocs/index.php?plpgsql-porting.html#PLPGSQL-QUOTI
NG-TABLE for details.

Regards, Dave.