Re: [GENERAL] using NOT EXISTS

On Thu, Mar 23, 2000 at 12:14:51PM -0600, Kevin Heflin wrote: > > > What's wrong with *just* the first select? > > The first select only grabs projects which have subprojects assigned to > them. I'm trying to figure out how to also grab projects which have no > subprojects assigned to them yet.

Re: [GENERAL] auto increment

i believe you're interested in creating a sequence. bruce momjian's book, in .pdf, covers this in section 7.4. the book can be found @ www.postgresql.org/docs/awbook.html i've found it a great reference for those topics covered. cheers, james On Thu, 23 Mar 2000, [EMAIL PROTECTED] wrote: > How

[GENERAL] TCL fonts

I am trying to run pgaccess from a remote X client. However all of the text on the screen is unreadable. Does anyone know what font the TCL front-end for pg uses? Dan Denault Network Administrator Corporation for Standards and Outcomes Phone: 412.968.3727 Fax : 412.968.3737 Cell : 412.370.3412

Re: [GENERAL] auto increment

> i believe you're interested in creating a sequence. bruce momjian's book, > in .pdf, covers this in section 7.4. the book can be found @ > www.postgresql.org/docs/awbook.html > i've found it a great reference for those topics covered. > I am working hard to finish it in the next month. -- B

[GENERAL] A Version for SGI IRIX

Is there a version of PostgreSQL that can be utilized for SGI IRIX (v6.5 .x) I would love to be able to try out this product for use on the SGI platform. If any of the binaries that currently exist can be "made" for SGI IRIX I'd like to know . Thanks. Very Respectfully, David J. Javier Applie

[GENERAL] unexpected error with array

Hi, This example is straight from bruce's book but I am getting an error. Help! [PostgreSQL 6.5.3 on i386-pc-bsdi3.0, compiled by gcc2 ] test=> create table array_test (col1 integer[5], col2 integer[][], test-> col3 integer[2][2][]); CREATE test=> insert into array_test values('{1,2,3,4,5}', '{{

[GENERAL] Data Recovery - 6.4.2 to 6.5.3 disk file translation

I was running version 6.4.2 when I lost all the binaries. I still have all the data/* and data/base/* files. The port for FreeBSD is 6.5.3. I have it installed, now. The disk file formats changed between version 6.4.2 and 6.5.3. Is there a tool or mechanism to translate these files into a for