Re: [GENERAL] 6.4.2 on DEC Alpha

1999-05-27 Thread Sebestyen Zoltan
On Thu, 27 May 1999, Bruce Momjian wrote: I have heard this complaint before. Are you running 6.5beta or 6.4. I think this is fixed in 6.5beta. What is precompiling? I am not sure. I meant to say C preprocessing..

[GENERAL] interface to NeoWebscript 3.0

1999-05-27 Thread Thilo Riessner
Hi, since one month I am trying now to get the interface between NeoWebscript and PostGres working. But I don't succeed. I guess that there is an version conflict between the libpgtcl. I am using Postgres 6.4.1 and NeoWebscript 3.0 . NeoWebscript asks for libpgtcl.so.1.0 in the file http.conf

[GENERAL] geometric functions

1999-05-27 Thread Piotr Stelmaszyk
Hello, I'm taking part in writing application that displays every part of world map. I have in database classes containing: point-objects - (postrgesql point type) polygon-objects - (postrgesql polygon type) path-objects - (postrgesql path type) One of queries should do sth. like this:

[GENERAL] Support for Geometric Types

1999-05-27 Thread Paul Ramsey
I have a couple questions regarding the maturity of the support for geometric types: - is there support for indexing geometric types so that things like '=' operators and some of the other geometric operators are a bit faster? - are there any plans on extending some of the geometric operators

[GENERAL] using variable in nextval

1999-05-27 Thread George Wadsworth
Hi! I'm trying to use a variable as the sequence name in a nextval: using pgsql 6.4.2, PL/pgSQL called from a trigger -- site is a char() used to describe the location -- generation is an int used for generations of plants -- each site/generation combo has it's own sequence site := new.site; gen