Joe Conway wrote:
Peter Eisentraut wrote:
I suggest I should not be documented until it's fixed.

Doc patch attached for IS OF. Please apply.

That is not the right place for it. IS OF is an operator, not an SQL command.

OK. If the attached patch is acceptable/applied, I'll fix and resend the doc patch.



Hmmm, looks like I was a bit quick on the draw:


regression=# select f1 is null, f2 is null, f3 is null from foo;
 ?column? | ?column? | ?column?
----------+----------+----------
 f        | t        | f
 t        | f        | f
 f        | f        | t
(3 rows)

regression=# select f1 is of (int), f2 is of (text), f3 is of (float8) from foo;
?column? | ?column? | ?column?
----------+----------+----------
t | t | t
t | t | t
t | t | t
(3 rows)



It worked correctly for constants, but not fields from a table :(


Back to the drawing board (suggestions welcomed).

Joe


---------------------------(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