[MonetDB-users] use column names as column alias?
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
On Thu, Nov 29, 2007 at 01:58:32PM -0700, m h wrote:
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'
An . is an invalid identifier character.
Niels
-matt
SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
m h
-
Niels Nes