[SQL] How to install Postgres that supports 64-bit integer/date-time.

How to install Postgres 8.0.1 that supports 64-bit integer/date-time.   # ./configure --prefix=/usr/local/pgsql --with-tclconfig=/usr/local/lib --with-tcl checking build system type... sparc-sun-solaris2.8 checking host system type... sparc-sun-solaris2.8 checking which template to us

Re: [SQL] Odd error message (" hash indexes do not support whole-index

Tom Lane wrote: Good catch. But why are you using a hash index for this? Just experimenting - I was trying to determine whether a hash index would give better performance - the values are always unique except when they're 0 and < > relations are never needed. That particular query would have be

[SQL] RULE for mtime recording

Hi folks, I'd like to write an update rule, which touches the a mtime field (=current_timestamp) on normal update - when the mtime field isnt explicitly set. If the update query explictly sets an mtime value, this value has to be let through. my tables look like: -- base class CREATE T

Re: [SQL] Query question

I do some tests with your first query and it seems to works. Thanks a lot for your answer, i will post the final thought later Thanks again bye Franco Bruno Borghesi wrote: If you have a row every 15 seconds, the answer is quite easy: SELECT A1.date FROM activity A1 LEFT JOIN activity A2 ON (A2.

Re: [SQL] Function to either return one or all records

> -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 21, 2005 12:06 AM > To: Tambet Matiisen > Cc: KÖPFERL Robert; pgsql-sql@postgresql.org > Subject: Re: [SQL] Function to either return one or all records > > > "Tambet Matiisen" <[EMAIL PROTECTED]>