Re: [GENERAL] Slow lookups on dates? Or something else?

1999-10-26 Thread Zakkr
On Mon, 25 Oct 1999, Aaron J. Seigo wrote: > hi... > my experience has been that this: > >select date_time_field::date from table_name; > > is much faster than: > > select date_trunc('day',date) from table_name; > Yes, date_trunc() is comlicated routine, this func. must internal

[GENERAL] Windows Server?

1999-10-26 Thread Mike Brickman
What are the plans/timescales for a MS Windows postgreSQL server? Mike Brickman RADical Solutions e-mail: [EMAIL PROTECTED]

[GENERAL] subscirbe

1999-10-26 Thread rony khoury
 

Re: [GENERAL] How to make a research

1999-10-26 Thread Lincoln Yeoh
At 12:19 AM 26-10-1999 -0400, Bruce Momjian wrote: >> Hello, >> >> I've heard that the last version of PostgreSQL >> which i think is 6.5.2 allow to make a search >> in a attribute as a plain text search. >> How can i make that ? > >See contrib/fulltextindex for fast searching of that type. ~ op

Re: [GENERAL] current_timestamp and default now()

1999-10-26 Thread Charles Tassell
I believe it works if you put now() in single quotes. EG: create table test ( proposetime datetime not null default 'now()', ) At 10:07 PM 10/25/99, Lincoln Yeoh wrote: >At 01:05 PM 25-10-1999 PDT, amy cheng wrote: > >hi, there, > > > >I'm using: > > > >create table test ( > >propos

[GENERAL] initdb error->ld-elf.so.1: Shared object "libpq.so.2" not found

1999-10-26 Thread Courtney Thomas
Greetings ! I got the above error [see subject] when I attempted to "initdb". What's wrong and how do I fix it ? Appreciatively, Courtney 

Re: [GENERAL] initdb error->ld-elf.so.1: Shared object "libpq.so.2" not found^H

1999-10-26 Thread Jim Mercer
> I got the above error [see subject] when I attempted to "initdb". > > What's wrong and how do I fix it ? what operating system? -- [ Jim Mercer [EMAIL PROTECTED] +1 416 506-0654 ] [ Reptilian Research -- Longer Life through Colder Blood ] [ Don

Re: [GENERAL] initdb error->ld-elf.so.1: Shared object "libpq.so.2" not found^H

1999-10-26 Thread Courtney Thomas
Jim Mercer wrote: > > > I got the above error [see subject] when I attempted to "initdb". > > > > What's wrong and how do I fix it ? > > what operating system? > > -- > [ Jim Mercer [EMAIL PROTECTED] +1 416 506-0654 ] > [ Reptilian Research -- Longer Life t

Re: [GENERAL] current_timestamp and default now()

1999-10-26 Thread amy cheng
I guess it won't work for Transaction. not tested though. (need to put the program sleep a while). I just use 'current_timestamp(now)'::datetime in the program (yes, read off now or just get time from perl should also work. current_timestamp just save a little perl coding). Not really tested. I

Re: [GENERAL] Windows Server?

1999-10-26 Thread Bruce Momjian
> > What are the plans/timescales for a MS Windows postgreSQL server? > > Mike Brickman We run on NT now. -- Bruce Momjian| http://www.op.net/~candle [EMAIL PROTECTED]| (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Ch

Re: [GENERAL] initdb error->ld-elf.so.1: Shared object "libpq.so.2" not found^H

1999-10-26 Thread Courtney Thomas
Jim Mercer wrote: > > > I got the above error [see subject] when I attempted to "initdb". > > > > What's wrong and how do I fix it ? > > what operating system? > > -- > [ Jim Mercer [EMAIL PROTECTED] +1 416 506-0654 ] > [ Reptilian Research -- Longer Life t

Windows NT Service? was Re: [GENERAL] Windows Server?

1999-10-26 Thread Craig Spannring
Bruce Momjian writes: > > We run on NT now. > Has anyone tried running it as an NT service with the SRVANY.EXE program? -- === Life is short. | Craig Spannring Bike hard, ski fast. | [EMAI

[GENERAL] authenification problems with win32-psql-client

1999-10-26 Thread Werner Arnhold
Hello, I am forced to convince people to use PostgreSQL on a Win98 net. So I tried the postgresql-win32-client-6.4.2.zip The server is running on a linux box. After setup there started a window, issuing an error message that there is no server on the local host and then died. When try

Re: [GENERAL] New PostgreSQL book on web site

1999-10-26 Thread Brett W. McCoy
On Tue, 26 Oct 1999, Bruce Momjian wrote: > I am in the process of writing a book about PostgreSQL for Addison, > Wesley to be published in 2000. Cool! Brett W. McCoy http://www.lan2wan.com/~bmccoy -

[GENERAL] New PostgreSQL book on web site

1999-10-26 Thread Bruce Momjian
I am in the process of writing a book about PostgreSQL for Addison, Wesley to be published in 2000. The book is tentatively titled, "PostgreSQL: Introduction and Concepts." The book is on our web site now in HTML and PDF formats. It will be updated nightly as I continue writing the book. Go t

Re: [GENERAL] authenification problems with win32-psql-client

1999-10-26 Thread Doran L. Barton
Not long ago, Werner Arnhold proclaimed... > Hello, > > I am forced to convince people to use PostgreSQL on a Win98 net. So I > tried the > > postgresql-win32-client-6.4.2.zip > > The server is running on a linux box. After setup there started a window, > issuing an error message that th

[GENERAL] Creating case insensative Index

1999-10-26 Thread Vince DiCiero
I am receiving the following errors on creating an index using lower() on a varchar field db1=> create index fieldindexlower on table1(lower(fieldvalue) varchar_ops); ERROR: BuildFuncTupleDesc: function 'lower(varchar)' does not exist Do I need to convert the field to "text" or are there othe

Re: [GENERAL] Windows Server?

1999-10-26 Thread Mike Brickman
Is this a standard (official) NT build that I can download from somewhere or have you done your own conversion? Also will this run on Windows 98/95? Mike Brickman RADical Solutions e-mail: [EMAIL PROTECTED] Bruce Momjian writes: > > We run on NT now. > > -- > Bruce Momjian