Skip site navigation (1) Skip section navigation (2)

Re: SELECT 1st field

From: msi77 <msi77(at)yandex(dot)ru>
To: Jan Bakuwel <jan(dot)bakuwel(at)greenpeace(dot)org>
Cc: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: SELECT 1st field
Date: 2012-05-15 06:25:27
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
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(dot)bakuwel(at)greenpeace(dot)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

In response to

pgsql-sql by date

Next:From: Misa SimicDate: 2012-05-15 08:06:14
Subject: Re: SELECT 1st field
Previous:From: Jan BakuwelDate: 2012-05-15 06:01:34
Subject: SELECT 1st field

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group