Tom Lane <[EMAIL PROTECTED]> writes:

> Well, the point is that there are potentially three types of statements
> involved:
> 
>       1. SELECTs
>       2. Utility statements that can return tuples (EXPLAIN, SHOW, etc)
>       3. Utility statements that can't return tuples (ALTER, etc)

I'm not sure this matters, but of course there are other non-utility
statements like UPDATE and DELETE. Does SPI return SPI_OK_SELECT for those?

Because you can definitely do "EXPLAIN ANALYZE UPDATE ..." or "EXPLAIN ANALYZE
DELETE ...".

-- 
greg


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to