Nawigacja

SQLExamples

v26	v27
30	30	-- ogranicza filtr jeśli {value} zwraca pusty string
31	31	CASE WHEN NULLIF('{value}', '') IS NULL THEN adduid IS NULL ELSE adduid IN ({value}) END
	32
	33
	34	-- ogarnia puste wartości w parametrach (NULLIF)
	35	SELECT doc.doc_id AS keyval, 'DOCUMENT' AS clsnam, doc.dscrpt,
	36	to_char( doc.adddat, 'YYYY-MM-DD') AS datain
	37	FROM documents doc
	38	LEFT JOIN processes_view p USING (prc_id)
	39	WHERE gostof is null AND doc.copyof IS NULL
	40	AND doc.dscrpt !~ 'Powiadomienie: '
	41	AND prc_id::text = (COALESCE(NULLIF('{PROCESSES_ID}','0')::text, '0'))::text
	42	ORDER BY doc.adddat
32	43
33	44	}}}