Thread: pgsql/src include/utils/builtins.h backend/uti ...

CVSROOT:    /home/projects/pgsql/cvsroot
Module name:    pgsql
Changes by:    tgl@hub.org    01/06/09 18:16:18

Modified files:
    src/include/utils: builtins.h
    src/backend/utils/adt: network.c selfuncs.c

Log message:
    Teach convert_to_scalar about datatypes timetz, inet, cidr, macaddr.

* Tom Lane <tgl@hub.org> [010609 17:16]:
>
> CVSROOT:    /home/projects/pgsql/cvsroot
> Module name:    pgsql
> Changes by:    tgl@hub.org    01/06/09 18:16:18
>
> Modified files:
>     src/include/utils: builtins.h
>     src/backend/utils/adt: network.c selfuncs.c
>
> Log message:
>     Teach convert_to_scalar about datatypes timetz, inet, cidr, macaddr.
What does this mean for users of these types? (Can we now cast
directly? )

LER

>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

--
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Larry Rosenman <ler@lerctr.org> writes:
> * Tom Lane <tgl@hub.org> [010609 17:16]:
>> Teach convert_to_scalar about datatypes timetz, inet, cidr, macaddr.

> What does this mean for users of these types? (Can we now cast
> directly? )

No, it means the planner now has a clue about selectivity of range
queries for these datatypes, ie, it might possibly make the right
decision about seq vs index scan and so on.

            regards, tom lane