Re: Using Indices

Hi

You should use the original field name. You don't have to worry about the
indicies after they're created. Postgres uses them automagicaly whenever
she think they'll speed up your queries. The name of the index is choosen
to make it easy to understand what it's indexing (pers table, uid key in
your case)

Hope it helps.

Regards,
Patrik Kudo

ech`echo xiun|tr nu oc|sed 'sx\([sx]\)\([xoi]\)xo un\2\1 is xg'`ol
Känns det oklart? Fråga på!

On Sun, 1 Apr 2001, Alexander Lohse wrote:

> Hi,
>
> when I use phpPgAdmin to create DBs, my Indices are getting automatic
> names like : pers_UID_key
>
> I am getting confused about the name!
>
> Does that mean a need to do call this in a select query?
>
> "select * from pers where pers_UID_key = '...'"
>
> or do i call the original field?
>
> "select * from pers where UID= '...'"
>
> Thanx,
>
> Alex
> --
> ___________________________
> Alexander Lohse
> Human Touch Medienproduktion GmbH
> Am See 1
> 17440 Klein Jasedow
>
> Tel: (038374) 75211
> Fax: (038374) 75223
> eMail: al(at)humantouch(dot)de
> http://www.humantouch.de
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>