Refer to n'th field of a table? - Mailing list pgsql-general

From Wei Wang
Subject Refer to n'th field of a table?
Date
Msg-id 033101c3f6ef$9298f420$726ee880@weiwang
Whole thread Raw
Responses Re: Refer to n'th field of a table?  (Shridhar Daithankar <shridhar@frodo.hserus.net>)
List 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


pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: How do I get query result(select e.g.) from a dynamic command(EXECUTE)?
Next
From: Shridhar Daithankar
Date:
Subject: Re: Refer to n'th field of a table?