From: msi77 <msi77@yandex.ru>
To: Jan Bakuwel <jan.bakuwel@greenpeace.org>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: SELECT 1st field
Date: Tue, 15 May 2012 10:25:27 +0400
Message-ID: <498571337063127@web21g.yandex.ru> (raw)
In-Reply-To: <4FB1F13E.80302@greenpeace.org>
References: <4FB1F13E.80302@greenpeace.org>
Try this
create view v(id) as select * from func(5);
if your function returns one column.
15.05.2012, 10:01, "Jan Bakuwel" <jan.bakuwel@greenpeace.org>:
> 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
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: msi77@yandex.ru, jan.bakuwel@greenpeace.org
Subject: Re: SELECT 1st field
In-Reply-To: <498571337063127@web21g.yandex.ru>
* 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