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 l
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,
* 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, whi
* 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 ;-)
> I gave it another thought and
> I am now having somet
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, bu
* 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. (htt
Thank you
- Original Message -
From: "Stephan Szabo" <[EMAIL PROTECTED]>
To: "tuan" <[EMAIL PROTECTED]>
Cc:
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 float)/10 is 0.29
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
Hello Tom.
Am 02.05.2005 um 06:11 schrieb Tom Lane:
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 fundamen
