In the 7.3 documentation about character data types
(http://www.postgresql.org/docs/7.3/static/datatype-
character.html), it states:
"Tip: There are no performance differences between these* three
types, apart from the increased storage size when using the
blank-padded type."
*referencing character, character varying and text data types
Is that statement applicable to indexes applied to those
columns? Is there any difference in performance for an index
applied to a character, character varying and text data type?
Your input will be appreciated and will help to put an end to a
debate.
TIA,
Val
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
