Skip site navigation (1) Skip section navigation (2)

Valid casts & datatypes?

From: John McKown <jmckown(at)prodigy(dot)net>
To: PostgreSQL docs mailing list <pgsql-docs(at)postgresql(dot)org>
Subject: Valid casts & datatypes?
Date: 2000-09-09 15:14:14
Message-ID: Pine.LNX.4.21.0009091009210.22560-100000@linux2.johnmckown.net (view raw or flat)
Thread:
Lists: pgsql-docs
I've been going through the PostgreSQL documentation. I have not been able
to find what "casts" are valid. I.e. I can cast an int to a float by
putting a ::int4 on the variable name. I cannot cast a datetime to an
int. Is there a list of valid casts (from datatype -> to datatype)?

Also, it would be nice to have a short explanation of what the valid
datatypes are. In particular, I've run across some that I can't really
figure out (e.g. tinterval). It would be nice to have a single list of all
PostgreSQL datatypes and their ranges and general usage.

I know, I know, this is an open source project, so I could try to read the
source code and then share what I've found out. But I'm hoping that
somebody has already done this, because I'm not all that good at reading C
programs. Especially really, really complicated ones like PostgreSQL.

John


pgsql-docs by date

Next:From: Hannu KrosingDate: 2000-09-11 08:48:13
Subject: I'm unable to access CVS
Previous:From: Stuart SeeleyDate: 2000-09-08 02:16:45
Subject: Postgresql documentation : PostgreSQL Tutorial

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group