massive quotes? - Mailing list pgsql-hackers

From Andrew Dunstan
Subject massive quotes?
Date
Msg-id 3F4E4708.4030703@dunslane.net
Whole thread Raw
Responses Re: massive quotes?
Re: massive quotes?
List pgsql-hackers
What is the state of things regarding having to use massive strings of 
quotes like this (taken from the 7.3 docs)?:

a_output := a_output || '' if v_'' ||     referrer_keys.kind || '' like ''''''''''     || referrer_keys.key_string ||
''''''''''    then return ''''''  || referrer_keys.referrer_type     || ''''''; end if;''; 
 

This is truly ugly, IMNSHO. Perl has its q() construct - any chance of us doing something here?

I'm prepared to put in effort to implement a solution if there is agreement on what the solution should be. Maybe some
sortof magical operator/function?
 

cheers

andrew





pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: New array functions
Next
From: Andrew Dunstan
Date:
Subject: Re: Code revision