Tom Lane wrote:
"Dann Corbit" <[EMAIL PROTECTED]> writes:
[EMAIL PROTECTED] On Behalf Of Lorenzo Thurman
I have three tables using date fields. I want to retrieve the oldest
date contained in the tables. Can someone show me an example of a query
that would do that?
Just do a
Lorenzo Thurman wrote:
I have three tables using date fields. I want to retrieve the oldest
date contained in the tables. Can someone show me an example of a query
that would do that?
TIA
I think I have it, but if anyone has any comments, I'd appreciate it:
select min(old) as oldest
Brent Wood wrote:
Lorenzo Thurman wrote:
I have three tables using date fields. I want to retrieve the oldest
date contained in the tables. Can someone show me an example of a
query that would do that?
You could write a custom function doing the same sort of thing, or
(perhaps more portable
I have three tables using date fields. I want to retrieve the oldest
date contained in the tables. Can someone show me an example of a query
that would do that?
TIA
---(end of broadcast)---
TIP 6: explain analyze is your friend
What I was trying to do was export the database on one computer and import it onto another. I gave up trying to fix the export problem since I had an old backup of the database. It was old enough that it was short three tables, but I have the raw tab delimited data so I just reconstructed the datab
Thanks for the reply. I've tried recompiling with my install build
settings, but no luck. I've posted a message on the Gentoo forums.
Hopefully they will have an answer. If they do, I'll post back here for
future reference.
On Apr 19, 2005, at 1:01 AM, Tom Lane wrote:
Lorenzo
acuum inter-page delay feature.
- - pg-intdatetime : Enables --enable-integer-datetimes configure option, which changes PG to use 64-bit integers for timestamp storage
I think these may have been changed since the original install.
On Apr 18, 2005, at 11:57 p, Tom Lane wrote:
Lorenzo Thurman <
On Apr 18, 2005, at 4:46 p, Tom Lane wrote:
Also, does "select * from pg_user" provoke the same error in every
database of your installation, or only this one? If the latter,
it could be a data-corruption kind of problem.
I only have one database right now. When I try "select * from pg_user", I
I'm running postgresql 7.4.7 on x86 and have run into a problem trying
to export my database. When I use pg_dump --file=stats.out --format=t
printstats, (and I may have the syntax wrong), I get this error:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: did not find '}' a