Re: [DOCS] type casting reference? SOLVED

stig erikson wrote: hi. i need to cast from timestamp to seconds (in the form of integer). i have a table with a column: expiretime timestamp i have tried the following, it gives errors as below: SELECT expiretime::float4 AS timeleft FROM table WHERE something='1234'; ERROR: cannot

[DOCS] type casting reference?

hi. i need to cast from timestamp to seconds (in the form of integer). i have a table with a column: expiretime timestamp i have tried the following, it gives errors as below: SELECT expiretime::float4 AS timeleft FROM table WHERE something='1234'; ERROR: cannot cast type timestamp without time

[DOCS] 7.4.6 docs, chapter 21.2

7.4.6 docs, chapter 21.2 Routine Reindexing has a very limited amount of information. it would be good to know how much of this is taken care of VACUUM and under what circumstances it is needed to do reindex. it would also be good to add some information on how to disable/enable autoamtic reinde

[DOCS] PostgreSQL 8.0.0beta3 Documentation

http://developer.postgresql.org/docs/postgres/index.html third line: Copyright © 1996-2003 suggest change to: Copyright © 1996-2004 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org