From 3de8bc83658ad54834bd8e01d37fd165e85f4db9 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Thu, 13 Feb 2014 15:37:36 -0500 Subject: [PATCH] stylistic tweak - capitalize keyword Signed-off-by: Galen Charlton --- collectionHQ/functions.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/collectionHQ/functions.sql b/collectionHQ/functions.sql index 52f1e8c..36925ad 100644 --- a/collectionHQ/functions.sql +++ b/collectionHQ/functions.sql @@ -128,7 +128,7 @@ CREATE OR REPLACE FUNCTION collectionHQ.write_item_rows_to_stdout (TEXT, INT) RE WHERE id = lms_bib_id; SELECT collectionHQ.attempt_price(ac.price::TEXT), barcode, ac.status, REPLACE(create_date::DATE::TEXT, '-', ''), - CASE WHEN floating::int > 0 THEN 'Y' ELSE NULL END + CASE WHEN floating::INT > 0 THEN 'Y' ELSE NULL END INTO price, bar_code, status, date_added, rotating_stock FROM asset.copy ac WHERE id = item; -- 2.11.0