Re: [GENERAL] DO Statement Body Parameters

2011-03-24 Thread Pavel Stehule
2011/3/24 Willy-Bas Loos : > On Thu, Mar 24, 2011 at 1:33 AM, David Johnston wrote: >> >> I am not sure how I'd go about testing a parameterized >> query without using JDBC... > > How about this? > http://www.postgresql.org/docs/9.0/interactive/sql-prepare.html > HTH, > WBL you can't prepare a DO

Re: [GENERAL] DO Statement Body Parameters

2011-03-24 Thread Willy-Bas Loos
On Thu, Mar 24, 2011 at 1:33 AM, David Johnston wrote: > I am not sure how I'd go about testing a parameterized > query without using JDBC... > How about this? http://www.postgresql.org/docs/9.0/interactive/sql-prepare.html HTH, WBL > > > > > > > -- > Sent via pgsql-general mailing list (pgs

[GENERAL] DO Statement Body Parameters

2011-03-23 Thread David Johnston
I think I understand what is happening but am curious if something along these lines can be accomplished? Consider the following SQL statement (executed via JDBC against a 9.0.3 installation): DO $$ BEGIN PERFORM someexistingfunction ( ? ); END; $$ It appears that such a format is invalid since J