In SQL, given a table T, with two fields f1, f2,
is it possible to create an index such that the same record is indexed in the
index, once with field f1 and once with field f2. (I am not looking for a
compound index in which the key would look like , instead there should
be two entries in the
If we have a query of the form:
Select *, (Select * FROM T2 WHERE p2 = T1.p1) FROM T1 ORDER BY 1 WHERE p3 = 75
In the above query there is a subselect in the target list and the ORDERBY has
an ordinal number which indicates order by column 1. Does this mean that the
above query will return all
inheritance works in POstgres...
any help is greatly appreciated...
thanks
--- On Sun, 12/18/11, David Johnston wrote:
> From: David Johnston
> Subject: RE: [GENERAL] indexes and tables
> To: "'amit sehas'" , pgsql-general@postgresql.org
> Date: Sunday, December 1
HI,
we have a schema related question. We have 10 types of resource records.
Each one of these resource records has 3 fields (attributes) (lets say f1, f2,
f3)...these fields have similar meaning to the corresponding 3 fields
in each resource record although they be named slightly differently in
