On Tue, 2005-04-26 at 20:18 +, Lord Knight of the Black Rose wrote:
hey guys I have a question that I couldnt maneged to solve for the last 4
days. Im kinda new to these stuff so dont have fun with me if it was so
easy. Ok now heres the question.
[snip class assignment]
we'd all love
Cosimo Streppone [EMAIL PROTECTED] writes:
1) is it possible to know Pg backend uptime with
SQL queries? Or must I look at postmaster.pid file?
or even something else?
I suppose you mean postmaster uptime, not the lifespan of your own
connection. We don't track that at the moment, but
* Ramakrishnan Muralidharan [EMAIL PROTECTED] wrote:
Hi,
Going through you mail, I assume that you are updating the mtime
only after inserting the record.
An normal update (=done by an application or user) should also
update the mtime. But there's an replication subsystem, which
* Christoph Haller [EMAIL PROTECTED] wrote:
Hi,
I assume this still refers to
[SQL] RULE for mtime recording
from last Friday.
ehm, yeah. I forgot that I've already asked this stuff ...
hmmpf. seems I'm not getting younger ;-)
snip
I gave it another thought and
I am now having
Why does
select array(select array[1,2]);
give me an error: could not find array type for data type integer[]?
Is there a type-cast missing, or is this generally impossible? I was
expecting something like
{{1,2}}
In my real-world application, the subquery returns more than one pair
of ints, but
* Cosimo Streppone [EMAIL PROTECTED] wrote:
Hi,
I'm currently working on something like a `mytop' clone,
also written in Perl with DBI + DBD::Pg interface.
mytop is a command line utility that displays mysql
server status and clients connected modeled after
`top' unix utility.
Thank you
- Original Message -
From: Stephan Szabo [EMAIL PROTECTED]
To: tuan [EMAIL PROTECTED]
Cc: pgsql-sql@postgresql.org
Sent: Saturday, April 30, 2005 10:56 AM
Subject: Re: [SQL] Division in Postgre
On Sun, 24 Apr 2005, tuan wrote:
In sql server my division select cast(3 as
Leo Fink [EMAIL PROTECTED] writes:
Why does
select array(select array[1,2]);
give me an error: could not find array type for data type integer[]?
We don't do arrays of arrays. You seem to be hoping for a 2-D array,
which is something fundamentally different (even though some programming