From: Jan Bakuwel <jan.bakuwel@greenpeace.org>
To: pgsql-sql@postgresql.org
Subject: SELECT 1st field
Date: Tue, 15 May 2012 18:01:34 +1200
Message-ID: <4FB1F13E.80302@greenpeace.org> (raw)
Hi,
I've spend some time checking the documentation but haven't been able to
find what I'm looking for.
I've got a function that returns a set of integers and a view that
selects from the function.
What I need is the ability to name the column in the view, ie.
create function func(i int) returns setof integer as $$
...
...code
...
$$ language plpythonu volatile;
create view v as select 1 as "id" from func(5);
In other words I'd like to refer to the first (and only) field returned
and give that an alias, in this case "id".
In some SQL dialects you can use "select 1" to select the first field,
"select 2" to select the 2nd field and so on.
Any suggestions?
regards,
Jan
Attachments:
[application/pkcs7-signature] smime.p7s (3.6K, ../4FB1F13E.80302@greenpeace.org/2-smime.p7s)
download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jan.bakuwel@greenpeace.org
Subject: Re: SELECT 1st field
In-Reply-To: <4FB1F13E.80302@greenpeace.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox