Dynamic where clause in a stored procedure
Hi all, Is it possible in monetdb to use a dynamic where clause in a selection query inside a stored procedure? More specifically, i want to pass the clause as parameter. Thank you, Vassilis
Does the SQL standard allow this? If so how? Stefan ----- Original Message -----
Hi all,
Is it possible in monetdb to use a dynamic where clause in a selection query inside a stored procedure? More specifically, i want to pass the clause as parameter.
Thank you, Vassilis _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
Hai Vassilis, I think you can't pass anything else than scalar values as parameter. Regards, Jennie On Thu, Jan 31, 2013 at 02:14:06PM +0200, Vassilis Papakonstantinou wrote:
Hi all,
Is it possible in monetdb to use a dynamic where clause in a selection query inside a stored procedure? More specifically, i want to pass the clause as parameter.
Thank you, Vassilis _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
participants (3)
-
Stefan Manegold
-
Vassilis Papakonstantinou
-
Ying Zhang