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

Started by Tom Laneabout 25 years ago3 messagescomitters
Jump to latest
#1Tom Lane
tgl@sss.pgh.pa.us

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.

#2Larry Rosenman
ler@lerctr.org
In reply to: Tom Lane (#1)
Re: pgsql/src include/utils/builtins.h backend/uti ...

* 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

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Larry Rosenman (#2)
Re: pgsql/src include/utils/builtins.h backend/uti ...

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