> Ya know, this brings up an interesting question, would it be feasible to
> allow for a function of somekind to be applied as an argument to a
> primary key declaration? It would certainly be useful for character
> type pks in non-C locales.
Using this would require making non-standard changes to ddl statements and
thus is not good.
Best solution is as follows:
Planner must use index
CREATE TABLE foo ( bar CHAR(10) PRIMARY KEY );
for queries like
SELECT * FROM foo WHERE bar::CHAR(3)='ABC';
Can you make this patch or add this to todo list ?
Andrus.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
