Little early aren't you?
select now()::date gives me 2000-12-22
Hmm.. only one digit is odd.
--
Rod Taylor
There are always four sides to every story: your side, their side, the
truth, and what really happened.
- Original Message -
From: "Partyka Robert" [EMAIL PROTECTED]
this with a plpgsql function using EXECUTE but returning
the full result set will be troublesome for a while.
Till then, 2 queries...
--
Rod Taylor
There are always four sides to every story: your side, their side, the
truth, and what really happened.
BEGIN:VCARD
VERSION:2.1
N:Taylor;Rod;B
since).
--
Rod Taylor
There are always four sides to every story: your side, their side, the
truth, and what really happened.
- Original Message -
From: "Louis-David Mitterrand" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 20, 2001 12:27 PM
Subject: [GENERAL]
Sorry... Exact same data. Did a pg_dumpall from one to the other
first, then analyzed.
--
Rod Taylor
There are always four sides to every story: your side, their side, the
truth, and what really happened.
- Original Message -
From: "Joseph Shraibman" [EMAIL PROTECTED]
To:
no matter how small the
operation its doing.
--Rod Taylor
There are always four sides to every story: your side, their side, the
truth, and what really happened.
- Original Message -
From:
Trewern,
Ben
To: [EMAIL PROTECTED]
Sent: Friday, March 02, 2001 12:35
PM
PRIMARY KEY entry. Getting this key
before sometimes isn't an option (triggers handle them sometimes). If
I could have a pg_getlastprimarykey() function which returns a hash of
name / value pairs of the new key without using the OID it would be
ideal.
--
Rod Taylor
There are always four sides
of several hundred. Rules apply as
normal from there -- of course this breaks down when the master goes
down...
--
Rod Taylor
There are always four sides to every story: your side, their side, the
truth, and what really happened.
- Original Message -
From: "adb" [EMAIL
are in pg_trigger.
\d user
- Shows me Indicies, Constraints, lack of rules (all properly).
Doesn't show any triggers..
But have come up with no obvious inconsistencies which would cause
this.
7.1 Beta 5 is the version.
--
Rod Taylor
There are always four sides to every story: your side, their side
Adding a LIMIT 1 in the subplan may also help -- as you only need a
single match to make it true so additional finds are useless -- it'll
stop sooner or will be more likely to use an index than a full table
scan.
--
Rod Taylor
There are always four sides to every story: your side, their side
by default.
--
Rod Taylor
There are always four sides to every story: your side, their side, the
truth, and what really happened.
- Original Message -
From: will trillich [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 27, 2001 12:56 AM
Subject: Re: [GENERAL] last comma inside
On Fri, 2003-08-01 at 20:32, Mark Wong wrote:
On Fri, Aug 01, 2003 at 05:05:18PM -0700, Josh Berkus wrote:
Mark,
I've just got our DBT-2 workload (TPC-C derivate) working with
PostgreSQL using C stored functions and libpq. I'd love to get some
feedback.
I'm confused. Jenny
On Sat, 2005-04-02 at 21:48 +0200, Peter Eisentraut wrote:
Marc G. Fournier wrote:
d) Bringing PL/Java into core will force a consistent documentation
and, I imagine, a chapter of it's own in the main docs. I'm happy
to write most of it but English is not my native language. Whatever
portion of the table where an index scan would be a
loss based on current tuning parameters.
--
Rod Taylor pg [at] rbt [dot] ca
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 8: explain analyze is your friend
13 matches
Mail list logo