On Thu, Dec 23, 2004 at 11:57:09AM -0800, Sibtay Abbas wrote:
Hi,
> Can anyone tell me which field here is used to
> indicated the language of the function, in which it is
> written.
>
> like when we create a function we mention $$language
> bla in the end.
It's one of the options (options is a
On Wed, 2004-12-22 at 04:43, Tom Lane wrote:
> Bruce Momjian writes:
> > So what are we doing for 8.0?
>
> Well, it looks like RC2 has already crashed and burned --- I can't
> imagine that Marc will let us release without an RC3 given what was
> committed today, never mind the btree bug that Mark
hello,
typedef struct CreateFunctionStmt
{
NodeTag type;
boolreplace;
List *funcname;
List *parameters;
TypeName *returnType;
List *options;
List
Tom Lane wrote:
> Bruce Momjian writes:
> > I remember the other difference between 8.0 and pre-8.0. When a backend
> > has to write a block in 8.0, it does a write _plus_ fsync(), while in
> > pre-8.0 it did only a write. There was a proposal to pass backend write
> > information to the backgro
Bruce Momjian writes:
> I remember the other difference between 8.0 and pre-8.0. When a backend
> has to write a block in 8.0, it does a write _plus_ fsync(), while in
> pre-8.0 it did only a write. There was a proposal to pass backend write
> information to the background writer so it would kno
On Thu, Dec 23, 2004 at 10:46:26AM +0100, Michael Meskes wrote:
> Very early in its existance ecpg got an oracle compat hack that enabled
> it to do a connect with just the username and use the database as
> specified via PGDATABASE. It appears that this feature is not really
> used as it seems it
[EMAIL PROTECTED] writes:
> So it should NOT depend on full number of rows either, is this right ?
No, it's supposed to return a fraction.
regards, tom lane
---(end of broadcast)---
TIP 8: explain analyze is your friend
Michael Meskes <[EMAIL PROTECTED]> writes:
> Very early in its existance ecpg got an oracle compat hack that enabled
> it to do a connect with just the username and use the database as
> specified via PGDATABASE. It appears that this feature is not really
> used as it seems it segfault for quite so
[EMAIL PROTECTED] writes:
> On Thu, Dec 23, 2004 at 10:01:33AM -0500, Tom Lane wrote:
>> Right. This amounts to assuming that the join conditions and the
>> restriction conditions are independent, which of course is bogus,
>> but we really don't have enough information to do better.
> Doesn't JOI
"Andrew Dunstan" <[EMAIL PROTECTED]> writes:
> Now we just need to work out why the box is failing the oldstyle_length test
> - see
> http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=osprey&dt=2004-12-23%2005:00:22
Either the passing of arguments or the passing of the return value isn't
working t
[EMAIL PROTECTED] writes:
> Doing some tests I've found out that the returned value from the
> JOINSEL is applied to REL1.rows X REL2.rows, but REL1 and REL2
> are not 'base' table, rather relations with a number of
> rows once again estimated by other selectivity functions.
Right. This amounts
Rémi Zara said:
>>
>>> From pgbuildfarm, it seems that openBSD sparc64 does not exhibit the
>>> problem (it's not part of resultmap, and passes the float8 test).
>>
>> OK, never mind that then. Patch applied as-is.
>
> Cool, thanks !
>
Now we just need to work out why the box is failing the old
Very early in its existance ecpg got an oracle compat hack that enabled
it to do a connect with just the username and use the database as
specified via PGDATABASE. It appears that this feature is not really
used as it seems it segfault for quite some amount of releases.
While trying ot fix it I f
On Thu, Dec 16, 2004 at 03:12:21PM -0500, Greg Stark wrote:
>
> "Mark Cave-Ayland" <[EMAIL PROTECTED]> writes:
>
> > Well at the moment PostGIS has a RESTRICT function that takes an expression
> > of the formwhere column is a column consisting of
> > geometries and constant is a bounding box.
for all the hard work on 8.0, not to mention the new-look website. It's
all shaping up to be a good new year.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
15 matches
Mail list logo