Re: [ADMIN] SQL-Statement

2003-09-16 Thread colin roald
Quoth Markus Espenhain <[EMAIL PROTECTED]>: > SELECT * FROM Hauptantrag WHERE (select datenfeldname from > datenexport) > (select datum_von from datenexport) AND (select > datenfeldname from datenexport) < (select datenexport.datum_bis from > datenexport) limit 10; If I understand you right, you w

Re: [ADMIN] age of statistics

2003-09-05 Thread colin roald
Quoth colin roald <[EMAIL PROTECTED]>: > Is there a way to query the database to find out how old the current > table statistics are? That is, when the ANALYZE command was last run > on a given table? It seems like there ought to be a table somewhere > in pg_catalog I ca

[ADMIN] age of statistics

2003-09-04 Thread colin roald
Is there a way to query the database to find out how old the current table statistics are? That is, when the ANALYZE command was last run on a given table? It seems like there ought to be a table somewhere in pg_catalog I can't find it in the PostgreSQL Administrator documentation, nor by searchi