Thanks to Scott and Taras for pointing me to the crosstab functions. I
only had a quick look but they seem very helpful!
Kind regards,
Felix
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-gene
I think you should look at crosstab contrib module.
Regards,
Taras Kopets
On 9/30/08, Felix Homann <[EMAIL PROTECTED]> wrote:
> Hi Sam,
>
> Sam Mason wrote:
>> I think you may be trying to solve the wrong problem, what are you
>> really trying to do?
>
> Here you go. I have some tables created li
On Tue, Sep 30, 2008 at 11:45 AM, Felix Homann <[EMAIL PROTECTED]> wrote:
> Hi Sam,
> In other words, I would like to have a named column for every Name in the
> player table. I _can_ create such a view manually if I know each player.name
> beforehand, but I don't know how to automate it for any gi
Hi Sam,
Sam Mason wrote:
I think you may be trying to solve the wrong problem, what are you
really trying to do?
Here you go. I have some tables created like this:
CREATE TABLE player(
id INTEGER PRIMARY KEY,
name varchar(20)
);
CREATE TABLE transfer(
id SERIAL PRIMARY KEY,
fromID
>From what i know, Aliases are literals, they are not variables, hence they
cannot be derived from something. you can derive them outside the scope of
normal SQL by using functions or shell scripts, but probably not inside an
SQL context.
rgds,
dotyet
On Tue, Sep 30, 2008 at 12:10 PM, Scott Marlo
On Tue, Sep 30, 2008 at 8:29 AM, Felix Homann <[EMAIL PROTECTED]> wrote:
> _But_, I don't want to give the alias explicitely, instead it should be
> taken from a second table 'colnames', i.e. something like the line I sent in
> my initial mail. Any idea?
Then you'll have to build a query in plpgs
On Tue, Sep 30, 2008 at 03:21:53PM +0200, Felix Homann wrote:
> I would like to set an alias name for a column from a subquery, i.e.
> something like this:
>
> SELECT entry AS (SELECT name from colnames WHERE id=1) from entries ;
>
> Obviously it doesn't work _this_ way, but is there _any_ way t
Raymond O'Donnell wrote:
select entry from (select name from colnames where id = 1) as
entry_with_different_name;
...maybe?
Thanks Ray!
No, "entry_with_different_name" should be the result of "SELECT name
FROM colnames WITH id=1".
Kind regards,
Felix
--
Sent via pgsql-general mailing li
On 30/09/2008 14:21, Felix Homann wrote:
> I would like to set an alias name for a column from a subquery, i.e.
> something like this:
>
> SELECT entry AS (SELECT name from colnames WHERE id=1) from entries ;
select entry from (select name from colnames where id = 1) as
entry_with_different_na
Hi Jeffrey,
Thanks for your quick response!
Hoover, Jeffrey wrote:
select (SELECT name from colnames WHERE id=1) as entry from entries;
I think, I should have been a bit clearer in what I need:
I've got two tables, colnames and entries:
test=# SELECT * from colnames;
id | name
+
Hi,
I would like to set an alias name for a column from a subquery, i.e.
something like this:
SELECT entry AS (SELECT name from colnames WHERE id=1) from entries ;
Obviously it doesn't work _this_ way, but is there _any_ way to do it?
Kind regards,
Felix
--
Sent via pgsql-general mailing l
11 matches
Mail list logo