Re: [GENERAL] Windows Server?

1999-10-27 Thread Ted Nolan SRI Augusta GA
In message <[EMAIL PROTECTED]>you write: >> >> Is this a standard (official) NT build that I can download from somewhere >> or have you done your own conversion? > >It is part of the distribution. Get the tarball, and read the README.NT >file on the web site or in the doc directory. We should

[GENERAL] Auto Ordering

1999-10-27 Thread Shawn T. Walker
Hi All, I have a table of questions to be displayed to the user. Table: questions question_id SERIAL page int order int question varchar(100) answers text The field order is how the questions are sorted. How can I change change question 5 to be number one and have all the other questions re

Re: [HACKERS] Re: [GENERAL] Postgres INSERTs much slower thanMySQL?

1999-10-27 Thread Herouth Maoz
At 17:08 +0200 on 22/10/1999, Tom Lane wrote: > In the meantime, the conventional wisdom is still that you should use > COPY, if possible, for bulk data loading. (If you need default values > inserted in some columns then this won't do...) Yes it would - in two steps. COPY to a temp table that

Re: [GENERAL] Windows Server?

1999-10-27 Thread Bruce Momjian
> > Is this a standard (official) NT build that I can download from somewhere > or have you done your own conversion? It is part of the distribution. Get the tarball, and read the README.NT file on the web site or in the doc directory. We should have a binary available, but we don't. > > Al

RE: [GENERAL] FW: inheritance of functions

1999-10-27 Thread Andrzej Mazurkiewicz
Hello. Here is an example of my problem: ccbslin2:~/lipa$ psql -c "drop database archimp0;" template1 DESTROYDB ccbslin2:~/lipa$ psql -c "create database archimp0;" template1 CREATEDB ccbslin2:~/lipa$ psql -f funinh1.sql archimp0 BEGIN WORK; BEGIN CREATE TABLE A ( liczba float ); CREATE C

[GENERAL] how do you specify null date field thru ecpg?

1999-10-27 Thread bayard kohlhepp
i'm new to pgsql, and i'm trying to move data from another dbms into my pgsql tables. in pgsql, i can specify NULL for a nonexistent date field. in ecpg, i have not found a way to specify null data for a date field - i've tried 'NULL', spaces and null characters (0x00). how is it done? *

Re: [GENERAL] FW: inheritance of functions

1999-10-27 Thread Aaron J. Seigo
hi... > > Postgres automatically allows the created table to inherit functions on > > tables above it in the inheritance hierarchy. > > create table A ( > > . > > . > > ); > > > > create function F ... > > > > create table B ( > > .. > > ) inherits (A); > > > > Now I assume that I can someho

Re: [GENERAL] QUERY PLAN:

1999-10-27 Thread Ross J. Reedstrom
On Wed, Oct 27, 1999 at 11:03:45AM +0100, Tim Joyce wrote: > can someone point me at documentation so that i can unserstand the results > of an EXPLAIN, eg: > > Index Scan using words_id_idx on books_idx (cost=441.19 rows=7644 width=8) > > explain select * from books_idx where wrd_id=1; > > I

Re: [GENERAL] how to insert from sequence

1999-10-27 Thread Alain TESIO
> Hi all, > > I need help in inserting a value from sequence. My > code goes like this (from Java). I do face a syntax > level problem. > > statement.execute("insert into T_name (id) values (" + > nextval('s_name') + ")"); > > Thanks in advance for the help. nextval is a sql function, not ja

Re: [GENERAL] how to insert from sequence

1999-10-27 Thread Shadkam Islam
Try statement.execute("insert into T_name (id) values (nextval('s_name'))"); Regards, Shad. On Wed, 27 Oct 1999, soundar rajan wrote: > Hi all, > > I need help in inserting a value from sequence. My > code goes like this (from Java). I do face a syntax > level problem. > > statement.exec

[GENERAL] how to insert from sequence

1999-10-27 Thread soundar rajan
Hi all, I need help in inserting a value from sequence. My code goes like this (from Java). I do face a syntax level problem. statement.execute("insert into T_name (id) values (" + nextval('s_name') + ")"); Thanks in advance for the help. __ D

[GENERAL] how to insert from sequence

1999-10-27 Thread soundar rajan
Hi all, I need help in inserting a value from sequence. My code goes like this (from Java). I do face a syntax level problem. statement.execute("insert into T_name (id) values (" + nextval('s_name') + ")"); Thanks in advance for the help. __ D

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

1999-10-27 Thread Ted Nolan SRI Augusta GA
In message <[EMAIL PROTECTED]>you write: > >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. | Cr

[GENERAL] FW: inheritance of functions

1999-10-27 Thread Andrzej Mazurkiewicz
Since I have not got any reply I try GENERAL list. Regards, Andrzej Mazurkiewicz > -Original Message- > From: Andrzej Mazurkiewicz > Sent: 22 paYdziernika 1999 11:27 > To: '[EMAIL PROTECTED]' > Subject: inheritance of functions > > In Postgres Users Guide, CREATE TABLE section, t

[GENERAL] QUERY PLAN:

1999-10-27 Thread Tim Joyce
can someone point me at documentation so that i can unserstand the results of an EXPLAIN, eg: Index Scan using words_id_idx on books_idx (cost=441.19 rows=7644 width=8) explain select * from books_idx where wrd_id=1; I am paticularly interested in what the rows= figure means. TIA timj ***