On Wed, Aug 11, 2010 at 07:39:37PM -0400, Andrew Dunstan wrote:
On 08/11/2010 07:33 PM, David Fetter wrote:
I would be curious to the benefit of putting it in core. I have no
problem with the type but in core?
If it's not in core, the vast majority of users will not have it
installed
unbelievably illegible -u format patches are?).
I have every confidence that you, of all people, can arrange to use
'filterdiff --format=context' on attached patches automatically,
saving you some time and us some boredom :)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone
On Thu, Aug 12, 2010 at 09:53:54AM -0700, Joshua D. Drake wrote:
On Thu, 2010-08-12 at 09:44 -0700, David Fetter wrote:
On Thu, Aug 12, 2010 at 12:27:45PM -0400, Tom Lane wrote:
Robert Haas robertmh...@gmail.com writes:
Here's an updated patch, with the invalidation changes merged
frequently just there.
As we're improving enums (allowing them to be altered easily after
creation, etc.), it seems reasonable to provide ways to return them
from all kinds of PLs, including making this easier in C.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235
On Fri, Aug 13, 2010 at 01:33:06PM -0400, Robert Haas wrote:
On Fri, Aug 13, 2010 at 1:05 PM, David Fetter da...@fetter.org wrote:
On Fri, Aug 13, 2010 at 12:59:48PM -0400, Robert Haas wrote:
On Fri, Aug 13, 2010 at 12:55 PM, Joseph Adams
joeyadams3.14...@gmail.com wrote:
Indeed, a built
to be added to VIEWs:
http://archives.postgresql.org/pgsql-hackers/2010-08/msg01030.php
Comments welcome.
Please add this to the next commitfest :)
https://commitfest.postgresql.org/action/commitfest_view?id=7
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778
On Mon, Aug 16, 2010 at 02:25:50PM -0400, Robert Haas wrote:
On Sun, Aug 15, 2010 at 7:44 AM, Hitoshi Harada umi.tan...@gmail.com wrote:
We (Marko, David Fetter and I) discussed on IRC about design of
writeable CTEs. It does and will contain not only syntax but also
miscellaneous
On Mon, Aug 16, 2010 at 04:34:07PM -0400, Robert Haas wrote:
On Mon, Aug 16, 2010 at 3:00 PM, David Fetter da...@fetter.org wrote:
There has been previous talk of allowing WITH (COPY ...) and I am
personally of the opinion that it would be nice to be able to do
WITH (EXPLAIN ...). DDL
several different medians, each with distinguishing names?
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
On Wed, Aug 18, 2010 at 04:10:18PM +0200, Pavel Stehule wrote:
2010/8/18 David Fetter da...@fetter.org:
Which median do you plan to implement? Or do you plan to implement
several different medians, each with distinguishing names?
my proposal enabled implementation of any median like
On Wed, Aug 18, 2010 at 10:39:33AM -0400, Tom Lane wrote:
David Fetter da...@fetter.org writes:
Apart from the medians, which median-like aggregates do you have in
mind to start with? If you can provide examples of median-like
aggregates that people might need to implement as user-defined
On Wed, Aug 18, 2010 at 04:46:57PM +0200, Pavel Stehule wrote:
2010/8/18 Tom Lane t...@sss.pgh.pa.us:
David Fetter da...@fetter.org writes:
Apart from the medians, which median-like aggregates do you
have in mind to start with? If you can provide examples of
median-like aggregates
, as there is no single, authoritative median.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote!
Consider
.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote!
Consider donating to Postgres: http
, but the perfect is the enemy of the
good.
Percentile is already there as NTILE, a windowing function. Median
may be useful, but we pretty much can't just call it median.
Instead, we need to call it something like left_median or
arithmetic_median.
Cheers,
David.
--
David Fetter da...@fetter.org
On Thu, Aug 19, 2010 at 12:12:12PM -0500, Kevin Grittner wrote:
David Fetter da...@fetter.org wrote:
Median may be useful, but we pretty much can't just call it
median. Instead, we need to call it something like left_median
or arithmetic_median.
I think it would be reasonable
On Thu, Aug 19, 2010 at 01:25:36PM -0400, Tom Lane wrote:
David Fetter da...@fetter.org writes:
On Thu, Aug 19, 2010 at 12:12:12PM -0500, Kevin Grittner wrote:
http://www.merriam-webster.com/dictionary/median
If you do a google search for median and poke around, you'll find
many places
, the a
and d values seem to be accepted but not documented.
D'oh! Changed patch enclosed. Now in context format :)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
thing -- why is there an enum at all? Seems it'd be simpler
to assign the right value to the variable in the getopt() code to
start with.
That's a question for the patch author. I was just cleaning up the
docs :)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1
being the case above.
We could just go with whatever Oracle, DB2 and MS-SQL Server have,
assuming it's the same thing, until something appears in the SQL
standard.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype
On Thu, Aug 19, 2010 at 06:03:57PM -0400, Robert Haas wrote:
On Thu, Aug 19, 2010 at 5:53 PM, David Fetter da...@fetter.org wrote:
On Thu, Aug 19, 2010 at 05:40:46PM -0400, Tom Lane wrote:
Kevin Grittner kevin.gritt...@wicourts.gov writes:
Robert Haas robertmh...@gmail.com wrote:
I
Frobozz 3.1.4.1.5.2.6, not
3.1.4.1.5.2.5!).
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote!
Consider
On Fri, Aug 20, 2010 at 11:36:55AM -0700, David Wheeler wrote:
On Aug 20, 2010, at 11:34 AM, David Fetter wrote:
+1 for three-number versions...well, until we really see the light
and go to two-number versions. 8.3 and 8.4 are different enough
that they shouldn't even mildly appear
On Fri, Aug 20, 2010 at 07:59:55PM +0100, Greg Stark wrote:
On Fri, Aug 20, 2010 at 7:34 PM, David Fetter da...@fetter.org wrote:
+1 for three-number versions...well, until we really see the light
and go to two-number versions. 8.3 and 8.4 are different enough
that they shouldn't even
On Fri, Aug 20, 2010 at 11:48:12AM -0700, David Wheeler wrote:
On Aug 20, 2010, at 11:47 AM, David Fetter wrote:
No idea what you mean by that, but generally it's a bad idea to
switch from dotted-integer version numbers and numeric version
numbers. See Perl (Quel désastre!).
I'm
On Fri, Aug 20, 2010 at 04:41:20PM -0500, Jaime Casanova wrote:
On Fri, Aug 20, 2010 at 1:48 PM, David E. Wheeler da...@kineticode.com
wrote:
On Aug 20, 2010, at 11:47 AM, David Fetter wrote:
The current system give people the completely false impression
that 7.0 and 7.4 are somehow
, and (of course
;) writeable CTEs, would qualify under that second.
Open for discussion would be features like Can spit out, on demand,
any subset of the dependency graph for an object.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo
On Sun, Aug 22, 2010 at 10:03:32PM +0800, Quan Zongliang wrote:
Sure, I agree.
New patch attached. How about this?
Docs re-added. Please not to leave these out in future patches. :)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666
.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org
, which isn't that exciting,
Not to you, maybe, but to users, it's really handy to have intuitive,
rather than strictly orthogonal, ways to do things.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter
On Tue, Aug 24, 2010 at 10:40:30AM -0400, Tom Lane wrote:
So I got annoyed by $SUBJECT just now while chasing Wheeler's bug
report. Seems like this would be a good thing to print. Should
it appear always, or just with VERBOSE, or ???
+1 for always.
Cheers,
David.
--
David Fetter da
), ROW('1.2.23', '=', '1.2.23')])
(3 rows)
Look reasonable?
This would have helped me a good deal a couple of times this week :)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet
be a good deal
too sunny)
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote!
Consider donating to Postgres
of 2ndQuadrant's time on
this. :)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote
, but things still seem unclear. Do
we have a final agreed upon patch that I can use? Any links for that?
No.
That was a mite brusque and not super informative.
There are patches, and the latest from Fujii Masao is probably worth
looking at :)
Cheers,
David.
--
David Fetter da...@fetter.org http
On Tue, Aug 31, 2010 at 11:07:40PM +0200, Pavel Stehule wrote:
Hello
attached WIP patch.
I don't see it attached. Is it just me?
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP
On Tue, Aug 31, 2010 at 08:34:31PM -0400, Robert Haas wrote:
On Tue, Aug 31, 2010 at 6:24 PM, David Fetter da...@fetter.org wrote:
On Tue, Aug 31, 2010 at 05:44:15PM -0400, Bruce Momjian wrote:
fazool mein wrote:
Hello everyone,
I'm interested in benchmarking synchronous replication
for removing the NULLs.
WHERE clause :P
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote
* Detecting errors
* Issuing ROLLBACKs to the aforementioned SAVEPOINT
None of this works super well for a bulk load.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal
Hello,
At work, I've been tasked with providing some Windows connection
libraries, etc. Are people still using MinGW, or should I just
recommend using a proprietary toolkit to do the builds? If so, which
one(s)?
Cheers,
David (Windows n00b)
--
David Fetter da...@fetter.org http://fetter.org
;
-- if it works
RELEASE my_savepoint;
-- if it fails
ROLLBACK TO my_savepoint;
RELEASE my_savepoint;
Granted, it's not super-performant ...
We have no mechanism to do this, or any other check, during a bulk
load. It'd be a great feature to have :)
Cheers,
David.
--
David Fetter da...@fetter.org
On Fri, Sep 03, 2010 at 06:24:06PM +0200, Magnus Hagander wrote:
On Fri, Sep 3, 2010 at 17:18, Dave Page dp...@pgadmin.org wrote:
On Fri, Sep 3, 2010 at 4:11 PM, David Fetter da...@fetter.org wrote:
Hello,
At work, I've been tasked with providing some Windows connection
libraries, etc
be here as with previous builds:
http://www.enterprisedb.com/products/pgdevdownload.do
I hate to mention this at this late date, but it just occurred to me
that the ordering is Alpha, then Beta, then Release Candidates, then
Release. Did I get that wrong?
Cheers,
David.
--
David Fetter da
of recording
ignorance (other than NULL, that is ;)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember
On Mon, Sep 06, 2010 at 01:11:03PM -0700, David Fetter wrote:
On Mon, Sep 06, 2010 at 08:07:33PM +0100, Dave Page wrote:
On Mon, Sep 6, 2010 at 7:41 PM, Peter Eisentraut pete...@gmx.net wrote:
On mån, 2010-09-06 at 19:38 +0100, Dave Page wrote:
On Mon, Sep 6, 2010 at 6:54 PM, Peter
if you decide
to do the work to fix them, and by the time you've done that work,
your youth will also be waning ;)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal
ROLE read_only FREEZE transaction_isolation;
I'd think of the reverse of each of these as GRANT and ALTER ... THAW,
respectively.
Is anyone else interested in such a feature? If so, is it more
DCL-ish, or more DDL-ish?
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1
On Tue, Sep 07, 2010 at 12:41:51PM -0700, Jeff Davis wrote:
On Tue, 2010-09-07 at 11:39 -0700, David Fetter wrote:
We'd like to create a role called read_only, with eponymous
capability.
Seems useful.
Great to hear :)
If so, is it more
DCL-ish, or more DDL-ish?
I don't like
On Tue, Sep 07, 2010 at 02:43:12PM -0700, Jeff Davis wrote:
On Tue, 2010-09-07 at 13:30 -0700, David Fetter wrote:
Offhand, I'm not thinking of past examples of mutating/disappearing
GUC that people would want to freeze, nor of a new GUC that would
negate or substantially alter
mentioning cos its just
the Byzantine Generals problem.
For completeness, a reference to the aforementioned Byzantine
Generals: http://en.wikipedia.org/wiki/Byzantine_fault_tolerance
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo
.
I'd suggest e for external. M for management is a pretty
useless mnemonic --- what's being managed?
\def, \deu, etc. sound great :)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP
On Mon, Nov 17, 2008 at 10:37:41AM -0800, David Fetter wrote:
On Tue, Nov 04, 2008 at 12:23:55PM -0500, Tom Lane wrote:
Alex Hunsaker bada...@gmail.com writes:
On Thu, Oct 30, 2008 at 05:16, Tom Lane t...@sss.pgh.pa.us wrote:
which doesn't seem like it would amount to anything compared
On Mon, Dec 15, 2008 at 08:50:25AM -0500, Tom Lane wrote:
David Fetter da...@fetter.org writes:
Tom,
I know you've been busy with lots of stuff, so here's a little
reminder. I talked with a couple of people who know the back-end
much better than I do. One said the above was way
be a good starting point for discussions and a way to move forward.
Any word on moving partitions off-line and back on? This is a very
common use case, so if it's not supported, it'd be good to document
that this is so :)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1
to restore.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via pgsql-hackers
it, but I'm not coming up with
anything good; the best I can do after a long day is EvalWindow,
and that doesn't seem particularly inspired. Any suggestions?
QueryWindow? ResultSetWindow?
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666
for table inheritance is
in table partitioning, can we see about deprecating ONLY (in the table
inheritance sense) for the next couple of development cycles and then
removing it?
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
On Sun, Dec 21, 2008 at 11:06:09PM -0500, Tom Lane wrote:
David Fetter da...@fetter.org writes:
Given that the main (and only sane, IMHO) use for table inheritance is
in table partitioning, can we see about deprecating ONLY (in the table
inheritance sense) for the next couple of development
-freebsd module that uses the base system uuid
functions rather than the ossp ones. I could put this on pgfoundry if
there isn't likely to be a real fix in the near future.)
+1 for putting it on pgFoundry.
It's now on pgfoundry :)
Cheers,
David.
--
David Fetter da...@fetter.org http
.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via pgsql-hackers
note though that we have a lot of other non-recursive maintenance
operations (CLUSTER, some variants of ALTER TABLE, etc) ... are we
going to try to make them all recursive?
We probably should.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM
On Tue, Dec 30, 2008 at 04:07:33PM -0500, Jaime Casanova wrote:
On Tue, Dec 30, 2008 at 2:00 PM, David Fetter da...@fetter.org wrote:
Here's one such use-case. Let's say a table has gotten large and
you've decided to partition it. You add child tables, add one or
more triggers
, it seems kind of inconsistent to do this for window functions
unless we also make \df start putting parens around the argument lists
for regular functions. Comments?
Would parens around all the argument lists really be so bad? I'm
thinking not.
Cheers,
David.
--
David Fetter da...@fetter.org
Alvaro's suggestion.
+1 for broken-out fields in columns per Alvaro.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres: http
, so +1 on the SRF option :)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
-
(0 rows)
!?
No !? at all. The = operation on floats has never been one to
count on. If you need = not to give surprising results, you need
to use some other data type such as numeric.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM
to GRANT/REVOKE :)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via
On Thu, Jan 08, 2009 at 02:39:52PM +0200, Peter Eisentraut wrote:
David Fetter wrote:
+1 for adding recursion to GRANT/REVOKE :)
This area is under SQL standard control, so we can't really invent our
own behavior.
Consider the following:
CREATE TABLE persons (name, email);
CREATE TABLE
git, as many hackers and committers have already
started to do. This is the kind of situation where CVS just plain
falls down because branching and merging are unmanageably difficult in
it, where in git, they're many-times-a-day operations.
Cheers,
David.
--
David Fetter da...@fetter.org http
On Mon, Jan 12, 2009 at 11:33:43AM -0500, Tom Lane wrote:
David Fetter da...@fetter.org writes:
Two things to fix this, and several other problems:
1. Remove the messages size limits on -hackers. They serve no
useful purpose, and they interfere with our development process.
Agreed
move the main repo to
git crowd, all you need for what you're suggesting here is a
stable git mirror on git.postgresql.org.
Agreed :)
Cheers,
David (happy to help by setting people up on git.postgresql.org).
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM
just need to enforce that 'git push' only ever did a
fast-forward.
We could do this using git's configuration:
http://www.kernel.org/pub/software/scm/git/docs/git-config.html
See receive.denyNonFastForwards, which is built for just this purpose :)
Cheers,
David.
--
David Fetter da...@fetter.org
On Mon, Jan 12, 2009 at 08:12:46PM -0500, Tom Lane wrote:
250K ought to be enough.
...for anybody ;)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember
is not.
Neither is I need to see system objects by default, despite what
some people whose day job is hacking on PostgreSQL may believe.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet
better than nothing, but it still doesn't help when I want to do:
psql -c '\df' | grep bool
psql -c '\dfS' |grep bool
This is not a made-up use case.
Nor is does this long overdue change impose an undue burden on it :)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1
by typ order by ts desc)
WHERE
typ 4;
ERROR: syntax error at or near WHERE
LINE 8: WHERE
^
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember
On Fri, Jan 16, 2009 at 12:23:16PM -0500, Jaime Casanova wrote:
On Fri, Jan 16, 2009 at 12:07 PM, David Fetter da...@fetter.org wrote:
Now i want only 3 records for every typ:
test=# select typ, ts, rank() over (partition by typ order by ts desc )
from foo where rank = 3;
ERROR
On Fri, Jan 16, 2009 at 12:34:34PM -0500, Tom Lane wrote:
David Fetter da...@fetter.org writes:
I tried this:
SELECT
typ,
ts,
rank() over w AS foo_rank
FROM
foo
WINDOW w AS (partition by typ order by ts desc)
WHERE
foo_rank 4;
ERROR: syntax
On Fri, Jan 16, 2009 at 12:41:59PM -0500, Tom Lane wrote:
David Fetter da...@fetter.org writes:
We don't appear to be able to use the actual thing in the target list
either.
Would you translate that into English? Or at least an example without
trivial syntax errors?
This works:
SELECT
:
: joe=w/postgres
: }
(1 row)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet
with something, but it will take some time; an
impending addition to the family currently has priority...
You understand that this means you need to provide blue-elephant-themed
photos, right?
Congratulations! :)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM
and ask when we'll have it. I've
never seen anything like the interest in this for any database
feature, including the fairies-and-unicorns multi-master replication
people imagine will scale linearly in every dimension by plugging in
nodes.
Cheers,
David.
--
David Fetter da...@fetter.org http
On Tue, Jan 27, 2009 at 11:36:02AM -0500, Tom Lane wrote:
David Fetter da...@fetter.org writes:
On Mon, Jan 26, 2009 at 03:12:02PM -0500, Tom Lane wrote:
I don't think this is correct.
I do.
People literally grab my shoulder and ask when we'll have it.
Do these people understand
On Thu, Jan 29, 2009 at 08:12:12PM -0500, Tom Lane wrote:
David E. Wheeler da...@kineticode.com writes:
Seems to me that IS DISTINCT FROM is just another operator, like
=,
Wishful thinking...
What would it take to make this wish come true?
Cheers,
David.
--
David Fetter da
On Sat, Jan 31, 2009 at 04:46:26PM +, Grzegorz Jaskiewicz wrote:
Hey folks,
I am trying to add GRANT SELECT ON ALL TABLES to postgres,
Is this part of the SQL:2008? If not, is there something else that
is?
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415
.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via pgsql-hackers mailing list (pgsql-hackers
the rolcanlogin value.
+1 for fixing that.
was it that easy, or I got it wrong?
:)
I think Stephen meant that they should add a column to the output.
Stephen?
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter
that seem to help significantly:
Are there any cases you've found where this change significantly
impairs performance, and if so, how did you find them? If not, would
you be up for trying to find some?
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM
fields and change spaces/tab to 4 spaces.
:)
+1 for adding this :)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres
On Wed, Feb 04, 2009 at 01:23:04PM -0500, Bruce Momjian wrote:
Robert Treat wrote:
On Wednesday 21 January 2009 20:21:41 Bruce Momjian wrote:
Alvaro Herrera wrote:
Robert Treat wrote:
On Thursday 08 May 2008 00:27:10 Tino Wildenhain wrote:
David Fetter wrote:
Ref: http
are equivalent to that
algorithm is no longer proprietary because any project could simply
use PostgreSQL's version and have done.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet
something else, or would you consider re-licensing it under
BSDL-compatible terms?
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating
On Sun, Feb 08, 2009 at 11:51:22AM -0500, Tom Lane wrote:
Now, if you want to argue that we should get rid of SET WITHOUT OIDS
altogether,
+1 for removing it altogether. Row OIDs are and ugly wart :P
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778
this:
You have explicit OIDs in this database, which have been
deprecated since 8.1. If despite this, you would like to preserve
them, use the --oids option for pg_dump.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo
, under no circumstances would such a
person paste that link in a public forum.
Should we have a kick-off policy for this kind of misbehavior?
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP
On Wed, Feb 11, 2009 at 09:36:38AM -0500, Jonah H. Harris wrote:
On Wed, Feb 11, 2009 at 8:05 AM, David Fetter da...@fetter.org wrote:
As has been discussed here many, many times, the only kind of
person who should be doing a patent search is a company's IP
attorney, which you
?
--num-bikeshed? ;)
Cheers,
David (purple!)
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
mobilizing them?
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via
: COPY delimiter must be a single character
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org
...@davidfetter=# SELECT 'abc' ~ '^[a]';
?column?
--
t
(1 row)
Did I misunderstand what SIMILAR TO does, or...?
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
801 - 900 of 2065 matches
Mail list logo