Skip site navigation (1) Skip section navigation (2)

Re: massive quotes?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: Postgresql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: massive quotes?
Date: 2003-08-30 15:42:45
Message-ID: 200308301542.h7UFgj707310@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Is there a TODO here?  The only problem I see is that it introduces the
idea of special column-1 handling, which we don't have right now, except
in COPY.

---------------------------------------------------------------------------

Andrew Dunstan wrote:
> Jon Jensen wrote:
> 
> >On Thu, 28 Aug 2003, Andrew Dunstan wrote:
> >
> >  
> >
> >>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 sort of magical
> >>operator/function?
> >>    
> >>
> >
> >I was thinking the most natural thing would be to use something similar to 
> >COPY's stdin quoting:
> >
> >CREATE FUNCTION bob() RETURNS INTEGER AS stdin LANGUAGE 'plpgsql';
> >BEGIN
> >	...
> >END;
> >\.
> >
> >Another possibility would be shell/Perl-style here documents, like this:
> >
> >CREATE FUNCTION bob() RETURNS INTEGER AS <<EOF
> >BEGIN
> >	...
> >END;
> >EOF
> >LANGUAGE 'plpgsql';
> >
> >The former seems preferable since it uses a syntax PostgreSQL already
> >supports in another context.
> >
> >Jon
> >  
> >
> 
> Nice idea. I would probably never have thought of it :-) Makes function 
> text almost first class, in the way that Oracle's is AFAICS,
> 
> I also prefer the first version, not least because it hoists the 
> LANGUAGE clause to the top where it seems to me it belongs.
> 
> I have no idea how hard this would be.
> 
> 
> cheers
> 
> andrew
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2003-08-30 15:54:33
Subject: Re: Bumping block size to 16K on FreeBSD...
Previous:From: Peter EisentrautDate: 2003-08-30 15:37:01
Subject: Re: [HACKERS] What goes into the security doc?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group