This profile is from a federated server and may be incomplete. Browse more on the original instance.
xocolatl, 9 months ago to postgres Hey #Postgres people. Do you use ±infinity in your dates and timestamps? What is your use case? What would you do instead if they weren't available? Please boost for reach. #PostgreSQL #SQL #Survey
Hey #Postgres people.
Do you use ±infinity in your dates and timestamps? What is your use case? What would you do instead if they weren't available?
Please boost for reach.
#PostgreSQL #SQL #Survey
truls46, 9 months ago @tshirtman If the column represents e.g. an expiration date (where NULL means "does not expire") you would need something like: WHERE col <= some_constant OR col IS NULL which typically won't use an index. When using +infinity the OR .. IS NULL is no longer necessary which then opens up the possibility to use an index.
@tshirtman
If the column represents e.g. an expiration date (where NULL means "does not expire") you would need something like:
WHERE col <= some_constant OR col IS NULL
which typically won't use an index.
When using +infinity the OR .. IS NULL is no longer necessary which then opens up the possibility to use an index.
tshirtman, 9 months ago @truls46 ok, for this case, where indeed you want to express "does not expire" (like, a permission, or something immaterial of the kind), i do think it make sense.
@truls46 ok, for this case, where indeed you want to express "does not expire" (like, a permission, or something immaterial of the kind), i do think it make sense.