<br><br><div class="gmail_quote">On 20 April 2011 15:30, Marco Milanesi <span dir="ltr"><<a href="mailto:marco.milanesi@eucentre.it">marco.milanesi@eucentre.it</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
hi all!<br>
<br>
are stored procedures inside a db covered by odbl or we have to use<br>
some other license? because stored procedures can be considered a "sql<br>
program".<br>
<br></blockquote><div><br>I doubt very much that they are. ODBL's definition is:<br><br>“Database” – A collection of material (the Contents) arranged in a
systematic or methodical way and individually accessible by electronic
or other means offered under the terms of this License.<br><br>And stored procedures aren't (unless you have a collection of them of course - which is a completely different question).<br><br>I doubt they fall within the database right either, which excludes computer programs "used in the making or operation of a database".<br>
</div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
For instance, imagine a schema and specific logic (stored procedure<br>
*FUNCTION*) added to the schema (in a separate file).<br>
<br>
i.e. to simplify things:<br>
<br>
schema.sql<br>
functions.sql<br>
<br>
How should I treat this piece of "sql code" (functions.sql)?<br>
<br></blockquote><div><br>As a computer program.<br> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Is it different if functions.sql it very tight to the db or if I have a<br>
generic "procedure" inside functions.sql?<br>
<br>
These are my doubts :)<br>
<br clear="all"></blockquote></div><br>I don't think the degree of proximity matters. They seem straightforward computer programs to me.<br><br>-- <br>Francis Davey<br><br><br>