Re: Access columns with index?

In <HWEDBXGE_at_gwdu03.gwdg.de> plewe_at_dl.mpi-dortmund.mpg.de (J.Plewe) writes:

>Is it possible to access columns using an index,
>let's say:
 

> select c(4) from strangetable;

That's not an index, it's a function (and a non-existent one at that)!

>I think, this is known as 'repeated fields' !??

And that's a no-no.

PS	CREATE INDEX c4 ON strangetable(c);
	That's an index!!!

graeme

--
Disclaimer:	The author's opinions are his own, and not necessarily
		those of Pyramid Technology Ltd. or Pyramid Technology Inc.
---------------------------------------------------------------------------
      -m------- Graeme Sargent                 Voice: +44 (0)252 373035
    ---mmm----- Senior Database Consultant     Fax  : +44 (0)252 373135
  -----mmmmm--- Pyramid Technology Ltd.        Telex: Tell who???
-------mmmmmmm- Farnborough, Hants  GU14 7PL   Email: graeme_at_pyra.co.uk
---------------------------------------------------------------------------
    We have the technology.  The tricky bit is learning how to use it.