Tom Lane wrote:
> [EMAIL PROTECTED] (Jan Wieck) writes:
> > One thing to keep in mind is that the LZ algorithm you're
> > thinking of must be distributable under the terms of the BSD
> > license. If it's copyrighted or patented by any third party,
> > not agreeing to these te
>not being from maryland but, i would think that the constitution's
>prohibition against ex post facto laws would prevent retro-active
>applications of laws, if the usa actually followed the constitution;
>but that's another topic...
Ex post facto seems pretty one way. If you drop a cigg butt on
I'm using PostgreSQL for an online game (www.merchantempires.net).
Running Vacuum analyze locks down the database. Unfortunately,
its a little disconcerting to my players when this occurs.
I've got people playing 24 hours a day.
My question is how can PostgreSQL ever be used for a database
that
Hi,
I compiled and installed PostgreSQL v7.0.2 on a Linux box where the
history function in psql (cursor up/down) worked without any
problems. After
that I recompiled the package on a Digital Unix 4.0d machine. But
there it is not working! Is there something I have to configure? I
tried to use se
Pre-7.x, we used to use a line like: " request.date_submitted > (now()
+ '24 hours ago')"
to pull data created in the past day (used against a timestamp).
Something changed with 7.x that blows that line out.
I am looking for a work around for use with 7.x. Currently I'm using
"select now()::DA
Mike Mascari wrote:
> Why do you continue to insist that GPL is superior to BSD? GPL is
> BSD *with restrictions*. If someone comes along and sweeps up the
> major developers:
>
> A) Good for the major developers - they deserve to have large
> sums of cash thrown their way, particularly for many
Hi there,
Does anyone know if out parameters are supported in pl/pgsql functions?
What I mean is something like this:
create function f(out int4) returns text as
'
select $1 = 3
return ""
' language 'plpgsql';
db ==> declare i int4;
db ==> select f(i);
db ==> select i;
i
==
3
On Thu, 6 Jul 2000, Tom Lane wrote:
> The Hermit Hacker <[EMAIL PROTECTED]> writes:
> > I would like to plug this in early next week, unless someone can see
> > something major that makes them feel uncomfortable ...
>
> What are you trying to do Marc, foreclose a full discussion? I think
> this
On Thu, 6 Jul 2000, Andrew Snow wrote:
> > See the documentation at:
> > http://www.comptechnews.com/~reaster/postgres/functions2976.htm
>
>
> So, something like:
>
> SELECT event FROM events WHERE to_char(CURRENT_TIMESTAMP, 'ww') =
> to_char(eventdate, 'ww');
A small note about 'WW' in to_
> Pre-7.x, we used to use a line like: " request.date_submitted > (now()
> + '24 hours ago')"
> to pull data created in the past day (used against a timestamp).
> Something changed with 7.x that blows that line out.
You will have to be more specific on what is not working for you. afaict
that l
> Does anyone know if out parameters are supported in pl/pgsql functions?
Yes. They are not supported. I've got patches ready to submit which
recognize the IN, OUT and INOUT keywords defined in SQL99, but the
patches will just throw an explicit error if you specify an OUT/INOUT
parameter.
btw, e
> ISO-week: week that has more than 4 day and start in Sunday.
> In future I try implement 'IW' that is ISO-week, but now I work on different
> things.
> In current 7.0 is probably better for week operations use
> date_part('week', TIMESTAMP) than to_char().
Note that the above returns ISO-week,
Mike Mascari <[EMAIL PROTECTED]> writes:
>> Are Partial Indices still supported into latest release of PostgreSQL?
> I think they have suffered some serious bit-rot over the years
> and are no longer functional, although some of the core code
> still exists in the backend.
Actually, quite a LOT
>On Thu, 6 Jul 2000, Tom Lane wrote:
>
> > The Hermit Hacker <[EMAIL PROTECTED]> writes:
> > > I would like to plug this in early next week, unless someone can
> > > see something major that makes them feel uncomfortable ...
> >
> > What are you trying to do Marc, foreclose a full discussion? I
>
I'm confused here as to why pppl keep going to the "BSD license is
flawed" argument? The only "flaw" that I can see is that a) the copyright
ended '96 and b) it only covers "UNIVERSITY OF CALIFORNIA" ... all that is
being proposed *at this time* is to add in coverage for the period *since*
'96 a
>Recently, Landmark/Great Bridge sent us a proposed revision to our
>existing license that, from what I can tell, has two paragraphs that
>pretty instantly none of the non-US developers felt comfortable with ...
>and that I, personally, could never agree to.
Sorry to jump in , but which two para
The Hermit Hacker <[EMAIL PROTECTED]> writes:
> On Thu, 6 Jul 2000, Tom Lane wrote:
>> The Hermit Hacker <[EMAIL PROTECTED]> writes:
I would like to plug this in early next week, unless someone can see
something major that makes them feel uncomfortable ...
>>
>> What are you trying to d
> yes, my current to_char() is almost compatible with oracle, but I need
> last two features --- IYYY (ISO-year) and IW (ISO-week). But I not explore
> it exactly yet. I mean that current (PG's) week-of-year is like ISO or not?
Yes. 'week' is "ISO week" (new for 7.0 afaicr). And it wasn't *entir
On Thu, 6 Jul 2000, Thomas Lockhart wrote:
> > ISO-week: week that has more than 4 day and start in Sunday.
> > In future I try implement 'IW' that is ISO-week, but now I work on different
> > things.
> > In current 7.0 is probably better for week operations use
> > date_part('week', TIMESTAMP)
I had sent this on to Marc as I did not want to fan the flames anymore
but on second thought - ah what the heck. Here goes. I'll take my
lumps! The cause seems just...
-- Forwarded message --
Date: Thu, 6 Jul 2000 08:41:23 -0400 (EDT)
From: Thomas Good <[EMAIL PROTECTED]>
To: T
Chris Bitmead wrote:
>
> > I would submit that most businesses don't know the difference. Perhaps
> > they need some education.
>
> Are you volunteering?
Of course. As the systems administrator for my company, I feel it's my
responsibility to inform the principals who run this company about
s
If I declare a cursor in embedded SQL I get a strange error wich
doesn't occur if I declare it manually with psql!
the code is:
void setSQL(PGconn *conn){
PQexec(conn,"SET DATESTYLE=European;");
PQexec(conn,"BEGIN TRANSACTION;");
PQexec(conn,"SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;")
On Wed, Jul 05, 2000 at 11:13:45PM -0300, The Hermit Hacker wrote:
> On Wed, 5 Jul 2000, Jim Wise wrote:
>
> > I'd like to point out a couple things that are _not_ wrong with the
> > current license:
> >
> > 1.) With the current license, contributors to the code are not opened
> > to legal l
At 10:19 6/07/00 -0400, Ron Peterson wrote:
>
>This has happened in PostgreSQL's own history. How long did it take for
>the project to get picked up again? How long did it take for the people
>who picked it up to familiarize themselves with the code? How long did
>it take before the community a
On Thu, 6 Jul 2000, Tom Lane wrote:
> The Hermit Hacker <[EMAIL PROTECTED]> writes:
> > On Thu, 6 Jul 2000, Tom Lane wrote:
> >> The Hermit Hacker <[EMAIL PROTECTED]> writes:
> I would like to plug this in early next week, unless someone can see
> something major that makes them feel un
The Hermit Hacker writes:
> Personally, I'd like the whole thing weeded down to ... get rid of the
> 'juristiction of ...' (which nobody outside of the US will agree to, from
> what I've been seeing on the list) ... and get rid of "Any person who
> contributes ..." paragraph, which several ppl ha
On Thu, 6 Jul 2000, Thomas Lockhart wrote:
> > yes, my current to_char() is almost compatible with oracle, but I need
> > last two features --- IYYY (ISO-year) and IW (ISO-week). But I not explore
> > it exactly yet. I mean that current (PG's) week-of-year is like ISO or not?
>
> Yes. 'week' i
On Thu, 6 Jul 2000, Richard Poole wrote:
> On Wed, Jul 05, 2000 at 11:13:45PM -0300, The Hermit Hacker wrote:
> > On Wed, 5 Jul 2000, Jim Wise wrote:
> >
> > > I'd like to point out a couple things that are _not_ wrong with the
> > > current license:
> > >
> > > 1.) With the current license, co
On Thu, 6 Jul 2000, Ron Peterson wrote:
> This has happened in PostgreSQL's own history. How long did it take
> for the project to get picked up again? How long did it take for the
> people who picked it up to familiarize themselves with the code? How
> long did it take before the community at
Philip Warner wrote:
>
> At 10:19 6/07/00 -0400, Ron Peterson wrote:
> >
> >This has happened in PostgreSQL's own history. How long did it take for
> >the project to get picked up again? How long did it take for the people
> >who picked it up to familiarize themselves with the code? How long d
>I'm confused here as to why pppl keep going to the "BSD license is
>flawed" argument? The only "flaw" that I can see is that a) the copyright
>ended '96 and b) it only covers "UNIVERSITY OF
>CALIFORNIA" ... all that is being proposed *at this time* is to add in
>coverage for the period *since*
[EMAIL PROTECTED] (Jan Wieck) writes:
>> As long as you brought it up: how sure are you that the method you've
>> used is not subject to any patents?
> Now that you ask for it: I'm not sure. Could be.
>> If you can show that this method uses no ideas not found in zlib,
>> then I'll feel reas
On Thu, 6 Jul 2000, Ron Peterson wrote:
> By the way, I hope I'm not coming across as saying "thanks for all
> your hard work, now go eat peanuts." I have great appreciation for
> what PostgreSQL has become, and for the developers who have made it
> so. That is why I keep at this tired argument
> > 1. How do you remove one of two identical rows
> > from a pgsql table ?
>
> DELETE FROM t1 WHERE wil do the stuff for you. If you don't know
> the value into the duplicate field just export the database with pg_dump
> create
> a unique index onto this field and reimport all your data. Du
Stephane Bortzmeyer wrote:
>
> On Thursday 6 July 2000, at 18 h 5, the keyboard of "Andrew Snow"
> <[EMAIL PROTECTED]> wrote:
>
> > SELECT event FROM events WHERE to_char(CURRENT_TIMESTAMP, 'ww') =
> > to_char(eventdate, 'ww');
>
> Sorry, I should have mentioned that I played with to_char and i
35 matches
Mail list logo
