List of casts in PostgreSQL

casts, postgresql, psql, timestamp

9^th of May 2005

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?)

Comment

	Name: Email: hide my email address. Your email address will be encoded to prevent email-extraction spiders from reading it so you won't get spammed if you decide to show your email address.
	What number is this?

Dear all people entering comments,
Due to an increase in comment spam I've had to make it mandatory to recognize the imagenumbers. If you're unable to post comments, please contact me as soon as possible.