[GENERAL] Inet and distinct bug or is it me? (v 6.5beta1)

1999-04-09 Thread Aaron Holtz
Howdy all. Running 6.5beta1 and am seeing an issue. It appears to be with the 'inet' type. Running a 'distinct' select against a column doesn't always provide the right data. I can find no reason why I'm getting multiple answers back. Example: db=> select distinct nasidentifier from table;

Re: [GENERAL] dbase converter

1999-04-09 Thread Patrick Welche
Thanks to all who responded! As you mentioned Xbase really makes life easy cf.http://www.startech.keller.tx.us/xbase/xbase.html Knocked something together using it, and it looks uncannily like pg2xbase, though the latter seems to need some fixing eg Pointer_to_Mem could be initialised to prevent a

[GENERAL] ERROR: ExecInitIndexScan

1999-04-09 Thread Mauro Bartolomeoli
I repeat the question because nobody answered. Please, if you know what the error on the subject means and how to avoid it, reply. I'm using Postgresql 6.3.2 on Linux RedHat 5.2. I receive the following error when I send a specific query to Postgres: ERROR: ExecInitIndexScan: both left and righ

Re: [GENERAL] dbase converter

1999-04-09 Thread Remigiusz Sokolowski
> > Is there a dbase3 <=> postgresql converter available at all? I found > > dbf2sql v2.2 which converts to (but not from) Postgres95, with notes such as > > > > -p primary: > > Select the primary key. You have to give the exact > > field-name. (Only for dbf2msql, Postgres95 doesn't have