Re: [HACKERS] PREPARE vs query with MULTIPLE statements

2007-11-20 Thread Andrei Kovalevski
Yes, Thank you! Tom Lane wrote: Andrei Kovalevski <[EMAIL PROTECTED]> writes: 2) If I send it as 'PREPARE "SQL_CUR1" AS SELECT 1; SELECT 2; SELECT3; SELECT4;' and then 'EXECUTE "SQL_CUR1" - I'm getting: - results for SELECT 1; SELECT2; SELECT 3; - ReadyForQuery response - results for SELECT

Re: [HACKERS] PREPARE vs query with MULTIPLE statements

2007-11-20 Thread Tom Lane
Andrei Kovalevski <[EMAIL PROTECTED]> writes: > 2) If I send it as 'PREPARE "SQL_CUR1" AS SELECT 1; SELECT 2; SELECT3; > SELECT4;' and then 'EXECUTE "SQL_CUR1" - I'm getting: > - results for SELECT 1; SELECT2; SELECT 3; > - ReadyForQuery response > - results for SELECT 4; > - one more ReadyForQuer

[HACKERS] PREPARE vs query with MULTIPLE statements

2007-11-20 Thread Andrei Kovalevski
Hello. I have found an interesting FRONTEND/BACKEND protocol behaviour. Let's consider following query: "SELECT 1; SELECT 2; SELECT3; SELECT4;" 1) If I send it as a simple query - I'm getting: - correct results for SELECT 1; SELECT 2; SELECT3; SELECT4; - and then one ReadyForQuery response fro