Can't figure out how to use now() in default for tsrange column (PG 9.2)
I'm trying to set [now(), 2049-12-31 00:00:00) as the default for a
tsrange column (Postgres 9.2), but can't figure out how to do it. I'm
either getting syntax errors or now() is being evaluated, so that the
default becomes something like [2012-07-14 14:04:35, 2049-12-31
00:00:00), which is not what I want. Can anyone point me in the right
direction, please?
Chris Bartlett <c.bartlett@paradise.net.nz> writes:
I'm trying to set [now(), 2049-12-31 00:00:00) as the default for a
tsrange column (Postgres 9.2), but can't figure out how to do it. I'm
either getting syntax errors or now() is being evaluated, so that the
default becomes something like [2012-07-14 14:04:35, 2049-12-31
00:00:00), which is not what I want. Can anyone point me in the right
direction, please?
I think you'd need to use the constructor function, ie
default tsrange(now(), '2049-12-31 00:00:00')
BTW, that second value looks a whole lot like a poorly thought out
substitute for 'infinity' ...
regards, tom lane