Re: Proposal: USING clause for DO statement - Mailing list pgsql-hackers

From Petr Jelinek
Subject Re: Proposal: USING clause for DO statement
Date
Msg-id 4B081CAE.6010005@pjmodos.net
Whole thread Raw
In response to Re: Proposal: USING clause for DO statement  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Proposal: USING clause for DO statement
List pgsql-hackers
I don't see point in having parameters for DO as an utility command. If 
you need to reuse some value you can define those variables at the 
beginning of code block in the language itself (in DECLARE section in 
plpgsql for example), defining them in outer SQL command does not really 
help anything. Now, if/when we add support to put DO inside standard sql 
query, it would be vastly more useful to be able to use parameters. But 
adding that support will be probably least of our problems if we try to 
do that, and we might even want to use different syntax/behavior then, 
so I would really not rush with this.

-- 
Regards
Petr Jelinek (PJMODOS)



pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Proposal: USING clause for DO statement
Next
From: Pavel Stehule
Date:
Subject: Re: Proposal: USING clause for DO statement