[GENERAL] Is this legal SQL? Is it a good practice?

2004-08-24 Thread Carlos Moreno
I just noticed that from a C or C++ program using libpq or libpq++, I can send *one* command that contains several SQL statements separated by semicolon. Something like: PgDatabase db ( ); const char * const sql = insert into blah (...); insert into blah (...); if (db.Exec (sql) ==

Re: [GENERAL] Is this legal SQL? Is it a good practice?

2004-08-24 Thread Peter Eisentraut
Carlos Moreno wrote: I just noticed that from a C or C++ program using libpq or libpq++, I can send *one* command that contains several SQL statements separated by semicolon. But I'm wondering -- is this a PostgreSQL extension, or is it legal SQL? The whole libpq API is made up out of thin

Re: [GENERAL] Is this legal SQL? Is it a good practice?

2004-08-24 Thread Carlos Moreno
Peter Eisentraut wrote: I just noticed that from a C or C++ program using libpq or libpq++, I can send *one* command that contains several SQL statements separated by semicolon. But I'm wondering -- is this a PostgreSQL extension, or is it legal SQL? The whole libpq API is made up out of thin