On Fri, 4 Aug 2006, Nikolay Samokhvalov wrote:
> On 8/4/06, Nikolay Samokhvalov <[EMAIL PROTECTED]> wrote:
> [...]
> > BTW, difference vanishes due to expression power of SQL -
> > it supports session comands in the same context as DDL commands and
> > data manipulation stmts (SQL:200n, 4.33.2.5 'SQL-connection
> > statements').
>
> Sorry, I already see my failure. It is in the fact that Postgres
> doesn't support that connection statements yet (but some connection
> things are supported - like changing the CURRENT_ROLE).
>
> So, my previous message is interesting only from theoretical point of
> view. I always try to thing in the manner of SQL standard or use
> knowledge from books/university ...
>
> But the logic is clear, isn't it? Connection is not client operation.
I'd read 4.39 differently which seems to imply that the SQL-client handles
the connection statements.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
