Dhimant Patel <drp4kri(at)gmail(dot)com> 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