[MonetDB-users] use column names as column alias?

29 Nov 2007


      Is it possible to use the column names as the alias?  The select query
below fails.

CREATE TABLE query_users (
        user_id INTEGER NOT NULL,
        user_name VARCHAR(20),
        PRIMARY KEY (user_id)
);

INSERT INTO query_users (user_id, user_name) VALUES (1,'matt');

select query_users.user_id AS "query_users.user_id",
query_users.user_name AS "query_users.user_name" from query_users;

Here's the error:
!Invalid identifier 'query_users.user_id'


-matt

m h

Niels Nes

tags

participants (2)