Re: [Pypgsql-users] ; being a terminator or separator

[Billy G. A. <bil...@mu...>]

Karsten Hilbert wrote:

>Billy,
>
>you stated that ; is a statement _separator_ in SQL which
>makes sense. However, this:
>
> http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=sql-syntax.html#SQL-SYNTAX-LEXICAL
> (1.1.4. Special Characters, 5th bullet)
>
>suggests otherwise. Given PGs track record of being (sanely)
>anal about SQL conformity I wonder what to make of it. I
>certainly am no expert on such matters.
>
>Thanks for your help,
>Karsten
>  
>
First,  I didn't say that, someone else on the list did ;-)
The point your refering to state a semi-colon is a command terminater.   
Multiple commands can be entered (even on the same line) terminated 
(seperated) by a semi-colon.  Commands are also terminated by the end of 
the input stream, which is why a semi-colon is not needed in the query 
given to the execute() method if there is only one command in the 
query.  Note that adding the semi-colon to a single command query does 
not cause any problems, it just terminates the one command.

I guess I'm trying to say is that if you equate 'statement' to 'command' 
and 'separator' to 'terminator', then there is no conflict.

-- 
___________________________________________________________________________
____       | Billy G. Allie    | Domain....: Bil...@mu...
|  /|      | 7436 Hartwell     | MSN.......: B_G...@em...
|-/-|----- | Dearborn, MI 48126|
|/  |LLIE  | (313) 582-1540    |