Re: [GENERAL] JOIN exclusion problem

Thank you both for your replies. Unfortunately, the AND solution doesn't work since individuals who have a value for ap.kunden_nr are not likely to have one for ap.agentur_nr -- they are two fairly distinct groups. When I insert AND, the results are blank. Any other suggestions? At 16:23 01.07

Re: [GENERAL] JOIN exclusion problem

I'm not sure that I understand exactly what you are trying to do. I'm guessing (and I mean guessing) that the tables are something like: ansprechpartner: private owner kunden: client agenturen: estate agent So are you trying to get is get details on all properties both privately rented and rent

[GENERAL] limits of float8

Dear all, What are the limits of float8? The user guide says variable-precision, 14 decimal places range but I'm not sure how that translates to a minimum value. I'm asking because I'm storing probability scores (range 0 to 1) with some scores very small indeed. The very small scores are all e

[GENERAL] alter table add column is broken in 6.5

I posted this yesterday and got no response, so I will try again. Alter table add column does not set the default value for new rows added to a table. I can except that it does not copy the new default value for existing rows. That is easy to work around. My problem is that the database does no

RE: [GENERAL] 6.4.2 and 6.5 date usertype difference

Cheers everyone. Therefore : - At runtime level : test=> show DATESTYLE; test=> SET DATESTYLE TO 'ISO'; - At boot up (/etc/rc.d/init.d/postgres) : Add : export PGDATESTYLE=ISO just before exec

Re: [GENERAL] JOIN exclusion problem

At 11:24 01.07.99 +0100, you wrote: >I'm not sure that I understand exactly what you are trying to do. I'm >guessing (and I mean guessing) that the tables are something like: > >ansprechpartner: private owner >kunden: client >agenturen: estate agent > The tables represent: ansprechpartner = cont

Re: [GENERAL] alter table add column is broken in 6.5

It's not too practical to insert a new row into the system table that handles the defaults, but here it goes. The table you are looking for is pg_attrdef and contains the following columns. adrelid -- The relation id for the table of the default value adnum -- The column number of the default co

Re: [GENERAL] JOIN exclusion problem

On Thu, Jul 01, 1999 at 03:43:27PM +0200, Anja Speerforck wrote: > At 11:24 01.07.99 +0100, you wrote: > >I'm not sure that I understand exactly what you are trying to do. I'm > >guessing (and I mean guessing) that the tables are something like: > > > >ansprechpartner: private owner > >kunden: cl

[GENERAL] LinuxPPC

Hi all - I scoured the archives and found information regarding changing the template settings for linux_ppc when configuring postgresql 6.5 for LinuxPPC R5. This is my situation 1) Installed R5 and downloaded postgresql 6.5. Configured, compiled and installed postgresql. created a db, did t

Re: [GENERAL] LinuxPPC

Thanks, but on the "About" page, it says they are using posgresql 6.4.2. I'm trying to figure out how to get 6.5 running correctly. Mike -- >From: Sascha Schumann <[EMAIL PROTECTED]> >To: "Mike Engelhart" <[EMAIL PROTECTED]> >Cc: [EMAIL PROTECTED] >Subject: Re: [GENERAL] LinuxPPC >Date: