Update of /cvsroot/monetdb/sql/src/test/Views
In directory sc8-pr-cvs16:/tmp/cvs-serv3521
Added Files:
view_functioncall.sql
Log Message:
--[ 1714814 ] View creation using a function....
--- NEW FILE: view_functioncall.sql ---
--[ 1714814 ] View creation using a function....
create table t1(id int, name varchar(1024), age int);
create table t2(id int, age int);
create function f1()
returns int
BEGIN
return 1;
END;
create view v1 as select * from t1 where id = f(1);
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
