Dhimant Patel <drp4kri@xxxxxxxxx> writes: > From my initial read on documentation I believe internally a date type is > represented by integer type of data. This makes me wonder would it make any > good to create additional column of Integer type and update it as data gets > added and use this integer column for all ordering purposes for my sqls - or > should I not hasitate using Date type straight into my sql for ordering? Don't overcomplicate things. Comparison of dates is just about as fast as comparison of integers, anyway. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
