[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:
Niels
-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl
participants (2)
-
m h
-
Niels Nes