- да се изведат имената и годината на производство на всички филми издадени м/у 1980 и 1995 година
SELECT
TITLE, YEAR
FROM
MOVIE
WHERE | (function() { | |
| var aval = 'val'; | |
| var res = []; | |
| Q.longStackSupport = true; | |
| console.log('start dfs'); | |
| function dfs(elem, level) { | |
| console.log('ENTER: ' + elem.tagName + ' level: ' + level + ' elem has ' + elem.childNodes.length + ' children'); |
| // Infite stream implementation with Basic promises. | |
| // inspired by | |
| // http://perl.plover.com/Stream/stream.html#streams | |
| var Stream = function(_head, _tail) { | |
| this.h = _head; | |
| this.t = _tail; | |
| }; |
| // rpn.cpp : micro example of RPN calculator | |
| // | |
| #include "stdafx.h" | |
| #include <stack> | |
| #include <iostream> | |
| using namespace std; | |
| char * rpns[] = { |
| create or replace function update_all_seqs(inc integer) returns void as $$ | |
| DECLARE | |
| r pg_class%rowtype; | |
| i name; | |
| isit integer; | |
| BEGIN | |
| FOR i in SELECT c.relname from pg_class c where c.relkind = 'S' LOOP | |
| isit := POSITION('pv_' in i); | |
| IF (isit = 1) THEN | |
| execute 'select last_value from visionr.' || i into isit; |
| #------------------------------------------------------------------------------ | |
| # CUSTOMIZED OPTIONS | |
| #------------------------------------------------------------------------------ | |
| # | |
| # this is from a Windows Server 2008 | |
| # with 2 drives in SAS array | |
| # and 32 GB of memory | |
| # memory consumption |
| UPDATE | |
| visionr.pv_m_itm iout | |
| SET | |
| protocol_stock = ( | |
| select | |
| child_object | |
| from | |
| visionr.pv_m_rel_1_n | |
| where |
| for v in $(find . | egrep \\\.xml); do | |
| xmlstarlet sel -t -c "//*[is_unique='false' and is_multiple='true']" $v; | |
| done |
| <objectdefs> | |
| <most module_alias="m" use_prefix="true"> | |
| <protocol_return parent_objectdef="most.protocol_stock"> | |
| <ref_sale> | |
| <category>most.related.protocols</category> | |
| <sort_id>189</sort_id> | |
| <data_source>relation</data_source> | |
| <is_obligatory>false</is_obligatory> | |
| <is_inmaintbl>true</is_inmaintbl> |
| function logsz(odef) { | |
| var sz = odef.SELECT().VALUE.size; | |
| java.log.info(odef + ".size == " + sz); | |
| } | |
| function test_h2() { | |
| java.log.info("=== collection sizes === "); | |
| logsz4all(); | |
| var pro = db.most.protocol.INSTANCES["INV0005891430/40"]; | |
| var dold = pro.official_date; |