Sequence should return values 1,2,3 etc starting for 1 for every day.
current\_date should used for day determination.

For example, calling today first time it shoudl return 1, in second time 2 etc.

Tomorrow, first call shoud return again 1, second call 2 etc.

Postgres 9.1 is used.