From: | "John Huttley" <john(at)mwk(dot)co(dot)nz> |
---|---|
To: | "pgsql-general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Limitation |
Date: | 1999-06-24 04:44:12 |
Message-ID: | 000c01bebdfc$355c4400$1401a8c0@Mr_Creosote.MWK.co.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I've been attempting to port applications from Pervasive SQL to PG.
Pervasive is interesting because it runs on top of btrieve. This allow
legacy apps
and SQL systems to co-exist. It's quirky and buggy, but it's better than PG
because it can do the following.
1. Have more than 7 fields on a btree index
2. There exists a table called inmaster it has a char(20) field called
stock_code.
pervasive can create a view (product) that splits the consituent characters
into fields.
PG cannot handle this. see below.
create view product as
Select code As Stock_Code,
Substr(Code,1,1) As Process_ID,
Substr(Code,2,2) As SubProcess_ID,
Substr(Code,4,1) As SubStrate_ID,
Substr(Code,5,2) As Length_ID,
Substr(Code,7,2) As Width_ID,
Substr(Code,9,2) As Thickness_ID,
Substr(Code,11,3) As Face_ID,
Substr(Code,14,1) As Facefinish_ID,
Substr(Code,15,3) As Back_ID
-- Substr(Code,18,1) As Backfinish_ID
>From INMASTER;
ERROR: DefineQueryRewrite: rule plan string too big.
This should not occur. Would someone please pick it up and put it on the
TODO list.
Regards
John
From | Date | Subject | |
---|---|---|---|
Next Message | Christian Rudow | 1999-06-24 05:49:11 | Re: [GENERAL] Limitation |
Previous Message | dustin sallings | 1999-06-24 01:26:05 | Re: [GENERAL] Date time insertion |