select column by position

This is a multi-part message in MIME format.

----=_NextPart_ST_12_50_37_Friday_September_24_2004_6647
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Is there a way to select a column in a table by its position rather than
the field name? If I understand correctly column position in a table is
fixed. I've not been able to find anything in the archives or docs to
indicate that it's possible to select by position.

For example:

CREATE TABLE Accessions (
accession_id INT8 PRIMARY KEY DEFAULT nextval('accession_id_seq'),
accenumb VARCHAR(255) NOT NULL,
instcode_id INT4 NOT NULL CONSTRAINT Accessions_instcode_id_fk
REFERENCES Institutions(institution_id),
accename VARCHAR(255)
);

I would like to select accession_id by indicating column 1 somehow. Is
this at all possible?

Cheers,
Jennifer

************************************************************ *****
DISCLAIMER:

This email is from the Scottish Crop Research Institute, but the views expr=
essed by the sender are not necessarily the views of SCRI and its subsidiar=
ies. This email and any files transmitted with it are confidential to the =
intended recipient at the e-mail address to which it has been addressed. I=
t may not be disclosed or used by any other than that addressee.
If you are not the intended recipient you are requested to preserve this co=
nfidentiality and you must not use, disclose, copy, print or rely on this e=
-mail in any way. Please notify mail [at] scri.sari.ac.uk quoting the name of th=
e sender and delete the email from your system.

Although SCRI has taken reasonable precautions to ensure no viruses are pre=
sent in this email, neither the Institute nor the sender accepts any respon=
sibility for any viruses, and it is your responsibility to scan the email a=
nd the attachments (if any).

----=_NextPart_ST_12_50_37_Friday_September_24_2004_6647
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" xmlns:w=3D"urn:sc=
hemas-microsoft-com:office:word" xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii">
<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 10">
<meta name=3DOriginator content=3D"Microsoft Word 10">
<link rel=3DFile-List href=3D"cid:filelist.xml [at] 01C4A234.E2E4EFB0">

<style>

</style>

</head>

<body lang=3DEN-GB link=3Dblue vlink=3Dpurple style=3D'tab-interval:.5in'>

<div class=3DSection1>

Is there a way to select a column in a table by its posi=
tion
rather than the field name? If I understand correctly column position in a
table is fixed. I’ve not been able to find anything in the archives or
docs to indicate that it’s possible to select by position.<o:p></o:p>=


<o:p> </o:p>

For example:<o:p></o:p>

<o:p> </o:p>

CREATE TABLE Accessions (<o:p></o:p>


accession_id INT8 PRIMARY KEY DEFAULT nextval('accession_id_seq'),<o=
:p></o:p>


accenumb VARCHAR(255) NOT NULL,<o:p></o:p>


instcode_id INT4 NOT NULL CONSTRAINT Accessions_instcode_id_fk
REFERENCES Institutions(institution_id),<o:p></o:p>


accename VARCHAR(255)<o:p></o:p>

);<o:p></o:p>

<o:p> </o:p>

I would like to select accession_id by indicating column=
1
somehow. Is this at all possible?<o:p></o:p>

<o:p> </o:p>

Cheers,<o:p></o:p>

Jennifer<o:p></o:p>

<o:p> </o:p>

</div>

</body>

**************************************************** ***************=
**********************
DISCLAIMER:
This email is from the Scottish Crop Research Institute, but the vi=
ews expressed by the sender are not necessarily the views of SCRI and its s=
ubsidiaries. This email and any files transmitted with it are confide=
ntial to the intended recipient at the e-mail address to which it has been =
addressed. It may not be disclosed or used by any other than that add=
ressee. If you are not the intended recipient you are requested to prese=
rve this confidentiality and you must not use, disclose, copy, print or rel=
y on this e-mail in any way. Please notify <A href=3D"mailto:mail [at] scri.sari=
..ac.uk">mail [at] scri.sari.ac.uk</A> quoting the name of the sender and delete =
the email from your system.
Although SCRI has taken reasonable precautions to ensure no viruses=
are present in this email, neither the Institute nor the sender accepts an=
y responsibility for any viruses, and it is your responsibility to scan the=
email and the attachments (if any). </html>

----=_NextPart_ST_12_50_37_Friday_September_24_2004_6647--

select column by position

Re: select column by position