From:
Vadim Mikheev <vadim(at)krs(dot)ru>
To:
Hannu Krosing <hannu(at)trust(dot)ee>
Cc:
Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>, pgsql-interfaces(at)postgreSQL(dot)org,
hackers(at)postgreSQL(dot)org
Subject:
Re: [INTERFACES] Re: [HACKERS] changes in 6.4
Date:
1998-07-15 20:25:44
Message-ID:
35AD1048.97441728@krs.ru (view raw or flat )
Thread:
1998-07-14 13:01:11 from t-ishii(at)sra(dot)co(dot)jp (Tatsuo Ishii)
1998-07-14 13:42:47 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1998-07-14 15:09:29 from "Thomas G(dot) Lockhart" <lockhart(at)alumnus(dot)caltech(dot)edu>
1998-07-14 15:37:17 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1998-07-15 10:04:26 from Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il>
1998-07-15 14:42:00 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1998-07-15 19:52:25 from Hannu Krosing <hannu(at)trust(dot)ee>
1998-07-15 20:23:47 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1998-07-15 20:25:44 from Vadim Mikheev <vadim(at)krs(dot)ru>
1998-07-15 20:39:39 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1998-07-16 07:45:18 from Maarten Boekhold <maartenb(at)dutepp0(dot)et(dot)tudelft(dot)nl>
1998-07-16 08:30:11 from Hannu Krosing <hannu(at)trust(dot)ee>
1998-07-16 08:51:35 from Vadim Mikheev <vadim(at)krs(dot)ru>
1998-07-16 10:56:40 from Hannu Krosing <hannu(at)trust(dot)ee>
1998-07-16 13:36:01 from "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
1998-07-16 18:29:26 from dg(at)illustra(dot)com (David Gould)
1998-07-16 18:37:17 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1998-07-15 20:40:56 from David Hartwig <daveh(at)insightdist(dot)com>
1998-07-15 21:02:40 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1998-07-16 10:35:30 from Aleksey Dashevsky <postgres(at)luckynet(dot)co(dot)il>
1998-07-16 15:33:35 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1998-07-16 17:27:03 from Peter T Mount <peter(at)retep(dot)org(dot)uk>
1998-07-15 22:16:02 from David Hartwig <daveh(at)insightdist(dot)com>
1998-07-15 23:39:05 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1998-07-16 01:22:33 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1998-07-16 08:41:47 from Hannu Krosing <hannu(at)trust(dot)ee>
1998-07-16 13:49:27 from "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
1998-07-17 07:18:03 from Hannu Krosing <hannu(at)trust(dot)ee>
1998-07-16 17:30:25 from Peter T Mount <peter(at)retep(dot)org(dot)uk>
1998-08-22 03:53:39 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1998-08-23 23:55:29 from David Hartwig <daybee(at)bellatlantic(dot)net>
1998-08-29 03:44:04 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1998-08-30 15:40:31 from David Hartwig <daybee(at)bellatlantic(dot)net>
1998-08-31 06:53:12 from Sbragion Denis <infotecn(at)tin(dot)it>
1999-09-18 20:10:11 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1999-09-19 11:17:49 from "Jason Doller" <jason(at)intekom(dot)co(dot)za>
1999-09-19 14:57:40 from "Brett W(dot) McCoy" <bmccoy(at)lan2wan(dot)com>
Lists:
pgsql-general pgsql-hackers pgsql-interfaces
Hannu Krosing wrote:
>
> Not requiring the column to sort on in target list ia also quite
> important.
I'm not sure but isn't this already in 6.4-current ?
>
> As are the (still elementary) constraints, still elementary becuse
> there is no way to use functions or "is null" in check constraint,
ispas=> create table t (x int, check (x is null or x = 5));
CREATE
ispas=> insert into t values (1);
ERROR: ExecAppend: rejected due to CHECK constraint $1
ispas=> insert into t values (null);
INSERT 168212 1
ispas=> insert into t values (5);
INSERT 168213 1
And I'm sure that functions are supported too. This is 6.3.2
> and constraints can be used only when defining tables, not in
> "alter table" construct.
I hadn't time to do this when implementing and have no plans
to do this. In "near" future :)
>
> > The days where every release fixed server crashes, or added a feature
> > that users were 'screaming for' may be a thing of the past.
>
> Is anyone working on fixing the exploding optimisations for many OR-s,
> at least the canonic case used by access?
>
> My impression is that this has fallen somewhere between
> insightdist and Vadim.
I'm not working...
Vadim
In response to
Responses
pgsql-hackers by date
Next :From: Bruce MomjianDate: 1998-07-15 20:39:39Subject : Re: [INTERFACES] Re: [HACKERS] changes in 6.4Previous :From : Bruce MomjianDate : 1998-07-15 20:23:47Subject : Re: [INTERFACES] Re: [HACKERS] changes in 6.4
pgsql-interfaces by date
Next :From: Bruce MomjianDate: 1998-07-15 20:39:39Subject : Re: [INTERFACES] Re: [HACKERS] changes in 6.4Previous :From : Bruce MomjianDate : 1998-07-15 20:23:47Subject : Re: [INTERFACES] Re: [HACKERS] changes in 6.4
pgsql-general by date
Next :From: Bruce MomjianDate: 1998-07-15 20:39:39Subject : Re: [INTERFACES] Re: [HACKERS] changes in 6.4Previous :From : Bruce MomjianDate : 1998-07-15 20:23:47Subject : Re: [INTERFACES] Re: [HACKERS] changes in 6.4
