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

Re: massive quotes?

From: "Andrew Dunstan" <andrew(at)dunslane(dot)net>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: massive quotes?
Date: 2003-09-01 00:57:16
Message-ID: 1543.24.211.141.25.1062377836.squirrel@www.dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackers
Bruce Momjian said:
> Let me jump in --- there is the issue of how to prevent the backend
> from running the query through the lexer/parser.  The cleanest idea
> presented was:
>
> 	>CREATE FUNCTION bob() RETURNS INTEGER AS stdin LANGUAGE 'plpgsql';
> 	>BEGIN
> 	>       ...
> 	>END;
> 	>\.
>
> The interesting thing I missed at first viewing was that there is a
> semicolon after the first line.  This allows the backend to go into a
> COPY-like mode where the client can pass lines to the backend bypassing
> the lexer/parser.
>

If it is all processed in the front end as Tom is suggesting, the backend
wouldn't see anything different from what it does now.

That said, I rather like this syntax.

cheers

andrew



In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2003-09-01 01:10:59
Subject: Re: Unixware Patch (Was: Re: Beta2 Tag'd and Bundled ...)
Previous:From: Bruce MomjianDate: 2003-09-01 00:47:41
Subject: Re: massive quotes?

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