Refer to n'th field of a table?

From: "Wei Wang" <ww220(at)cam(dot)ac(dot)uk>
To: "pgsql" <pgsql-general(at)postgresql(dot)org>
Subject: Refer to n'th field of a table?
Date: 2004-02-19 13:52:11
Message-ID: 033101c3f6ef$9298f420$726ee880@weiwang
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Sorry for asking the dynamic command question without thoroughly reading the
documentation first.
Thanks a lot for your reply, Richard. ;-)

Now this may be a naive SQL question:
Is there any way to refer to the nth field of a table? For example, when I
already know the schema of
a table( I know it's first field is integer, second and third are text), but
don't know the field names,
is there any way to simply refer to the field by it's position in the table
rather than it's field name?
Also the same question goes with a record(row)?

Many thanks,

Wei Wang

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2004-02-19 14:43:30 Re: Refer to n'th field of a table?
Previous Message Christopher Browne 2004-02-19 13:24:41 Re: Big Tables vs. many Tables vs. many Databases