[GENERAL] How to know the type of an expression ?

2006-10-29 Thread maa1666
Is there a means to know the type of an expression ? Something like a "typeof" function ? As I work a lot with numbers of type "numeric", I often want to know the precision of the result returned by an expression, in case the returned result is "numeric". I would also like to know if numbers of ty

[GENERAL] database corruption question

2006-10-11 Thread maa1666
In the document "Transaction Processing in PostgreSQL" ( http://www.postgresql.org/files/developer/transactions.pdf ) I read : "Postgres transactions are only guaranteed atomic if a disk page write is an atomic action. On most modern hard drives that's true if a page is a physical sector, but most

[GENERAL] how much free space in tables and index ?

2006-09-24 Thread maa1666
Hi, When tuples are deleted, there remains free space in table and index files. Is it possible to know for each table and index how much free space it contains ? Thanks ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send