Learned something new today that will come in very handy next time I'm about to pick up a manual or search the PostgreSQL documentation with Google.
In psql
if you run \dC
you get a list of casts. Here's the header:
List of casts
Source type | Target type | Function | Implicit?
------------------+-------------------+---------------+-------------
This is very handy when you need to know, for example, which cast to use when to cast a value of type date
to timestamp without time zone
you use timestamp
. Most of these are pretty obvious and the PostgreSQL book is never far away on my desk, but the interesting thing is that I came across this function by accident when running psql
.
(was this the most boring thing I've written here in a long time?)
Comments