Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fBGnR-00020W-CB for pgsql-sql@arkaria.postgresql.org; Wed, 25 Apr 2018 09:33:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fBGnP-0006VD-SY for pgsql-sql@arkaria.postgresql.org; Wed, 25 Apr 2018 09:33:03 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fBGnP-0006V4-Gt for pgsql-sql@lists.postgresql.org; Wed, 25 Apr 2018 09:33:03 +0000 Received: from forward5o.cmail.yandex.net ([2a02:6b8:0:1a72::28a]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fBGnH-0006n0-Rq for pgsql-sql@lists.postgresql.org; Wed, 25 Apr 2018 09:33:02 +0000 Received: from mxback5j.mail.yandex.net (mxback5j.mail.yandex.net [IPv6:2a02:6b8:0:1619::10e]) by forward5o.cmail.yandex.net (Yandex) with ESMTP id 5914321607; Wed, 25 Apr 2018 12:32:49 +0300 (MSK) Received: from localhost (localhost [::1]) by mxback5j.mail.yandex.net (nwsmtp/Yandex) with ESMTP id ehpdg69G5C-Wl00ugsp; Wed, 25 Apr 2018 12:32:48 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=reddoc.net; s=mail; t=1524648768; bh=HFkT2Vq4UthBK1AHECvgO831Za3OlNEsiR14BJskkDA=; h=From:To:In-Reply-To:References:Subject:Message-Id:Date; b=V0ahCHksKq5E5ux5y67U7p2tk73Nhi4r8zU89t71Wm/emreboPp99MbhpF4o7aLI1 +5pvIu5iAWwqdYf+ZhAMXDUrV06Pve7XY6D/rnsX7SL3BRdZpC9V6kOt9KbIi2uxX9 q/oNZqZxWj5c6l8XaUBvGTVo7+sWnkVRfSMQbdCg= Authentication-Results: mxback5j.mail.yandex.net; dkim=pass header.i=@reddoc.net Received: by web10o.yandex.ru with HTTP; Wed, 25 Apr 2018 12:32:47 +0300 From: Samed YILDIRIM To: Gary Stainburn , "pgsql-sql@lists.postgresql.org" In-Reply-To: <201804251006.11072.gary.stainburn@ringways.co.uk> References: <201804251006.11072.gary.stainburn@ringways.co.uk> Subject: Re: error in function, works when typed MIME-Version: 1.0 Message-Id: <8483951524648767@web10o.yandex.ru> X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Wed, 25 Apr 2018 12:32:47 +0300 Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk PGRpdj5IaSBHYXJyeSw8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5JdCBpcyByZWxhdGVkIHdpdGgg eW91ciB1cGRhdGUgbGluZSBpbiB0aGUgZnVuY3Rpb24uIFVwZGF0ZSBsaW5lIGlzIGZpbmlzaGlu ZyB3aXRoIHJldHVybmluZyBidXQgaXQgZG9lcyBub3QgaGF2ZSBhbnkgdGFyZ2V0IGZvciB0aGUg b3V0cHV0LiBZb3UgY2FuIHVzZSBjdGUgdG8gYWNoaWV2ZSB0aGlzLiBVcGRhdGUgbGluZSBzaG91 bGQgYmUgbGlrZSBmb2xsb3dpbmcuPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+d2l0aCBzcl91cGRh dGVfY3RlIGFzICh1cGRhdGUgc2VydmljZV9qb2JzIHNldCBzal9zdGF0ZT05MDxiciAvPsKgwqDC oMKgwqDCoHdoZXJlIHNqX2RhdGUgJmx0OyBDVVJSRU5UX0RBVEUgYW5kIHNqX3NyX2lkID0gU1JJ RCBhbmQgc2pfc3RhdGUgJmx0OyA5MDxiciAvPsKgwqDCoMKgcmV0dXJuaW5nIDEpIHNlbGVjdCBj b3VudCgqKSBpbnRvIFJPV0NPVU5UIGZyb20gc3JfdXBkYXRlX2N0ZTs8L2Rpdj48ZGl2PsKgPC9k aXY+PGRpdj5CZXN0IHJlZ2FyZHMuPC9kaXY+PGRpdj5TYW1lZCBZSUxESVJJTTwvZGl2PjxkaXY+ wqA8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+MjUuMDQuMjAxOCwgMTI6MDYs ICJHYXJ5IFN0YWluYnVybiIgJmx0O2dhcnkuc3RhaW5idXJuQHJpbmd3YXlzLmNvLnVrJmd0Ozo8 L2Rpdj48YmxvY2txdW90ZSB0eXBlPSJjaXRlIj48cD5JIGFtIHdyaXRpbmcgYSBmdW5jdGlvbiB0 byBjbGVhciBkb3duIG9sZCBqb2JzLjxiciAvPjxiciAvPkFzIHlvdSBjYW4gc2VlIGJlbG93LCB0 aGUgY29tbWFuZHMgd29yayB3aGVuIEkgdHlwZSB0aGVtIGluLCBidXQgd2hlbiBJIHRyeSB0bzxi ciAvPnVzZSB0aGVtIGluIGEgZnVuY3Rpb24sIHRoZSBpbnNlcnQgZmFpbHMuPGJyIC8+PGJyIC8+ QW55b25lIGdvdCBhbiBpZGVhIHdoeT8gVGhlIGVycm9yIHN1Z2dlc3RzIHRoYXQgdGhlIHNlbGVj dCBkb2VzIG5vdCBoYXZlIGE8YnIgLz5kZXN0aW5hdGlvbiwgYnV0IGl0IGZlZWRzIHRoZSBpbnNl cnQuPGJyIC8+PGJyIC8+LS0tLTxiciAvPmNyZWF0ZSBvciByZXBsYWNlIGZ1bmN0aW9uIHNlcnZp Y2VfY2xlYXJkb3duKFNSSUQgaW50ZWdlciwgVUlEIGludGVnZXIpPGJyIC8+UkVUVVJOUyBpbnRl Z2VyIGFzICQkPGJyIC8+REVDTEFSRTxiciAvPsKgwqBST1dDT1VOVCBpbnRlZ2VyOzxiciAvPkJF R0lOPGJyIC8+wqDCoHNlbGVjdCBjb3VudChzcl9pZCkgaW50byBST1dDT1VOVCBmcm9tIHNlcnZp Y2VfcmVjZXB0aW9ucyB3aGVyZSBzcl9pZCA9PGJyIC8+U1JJRDs8YnIgLz7CoMKgSUYgTk9UIEZP VU5EIFRIRU48YnIgLz7CoMKgwqDCoHJhaXNlIGV4Y2VwdGlvbiAnUmVjZXB0aW9uIElEIGludmFs aWQnOzxiciAvPsKgwqBFTkQgSUY7PGJyIC8+wqDCoGluc2VydCBpbnRvIHNlcnZpY2Vfam9ic19s b2cgKHNqX2lkLCBzal91X2lkLCBzal90ZXh0KTxiciAvPsKgwqDCoMKgc2VsZWN0IHNqX2lkLCBV SUQsJ0pvYiBjbGVhcmVkIGRvd24nIGZyb20gc2VydmljZV9qb2JzPGJyIC8+wqDCoMKgwqDCoMKg d2hlcmUgc2pfZGF0ZSAmbHQ7IENVUlJFTlRfREFURSBhbmQgc2pfc3JfaWQgPSBTUklEIGFuZCBz al9zdGF0ZSAmbHQ7IDkwOzxiciAvPsKgwqB1cGRhdGUgc2VydmljZV9qb2JzIHNldCBzal9zdGF0 ZT05MDxiciAvPsKgwqDCoMKgwqDCoHdoZXJlIHNqX2RhdGUgJmx0OyBDVVJSRU5UX0RBVEUgYW5k IHNqX3NyX2lkID0gU1JJRCBhbmQgc2pfc3RhdGUgJmx0OyA5MDxiciAvPsKgwqDCoMKgcmV0dXJu aW5nIFJPV0NPVU5UOzxiciAvPsKgwqBSRVRVUk4gUk9XQ09VTlQ7PGJyIC8+RU5EPGJyIC8+JCQg TEFOR1VBR0UgcGxwZ3NxbDs8YnIgLz4tLS0tPGJyIC8+PGJyIC8+Z29vbGU9IyBpbnNlcnQgaW50 byBzZXJ2aWNlX2pvYnNfbG9nIChzal9pZCwgc2pfdV9pZCwgc2pfdGV4dCk8YnIgLz7CoMKgwqBz ZWxlY3Qgc2pfaWQsIDI1LCdKb2IgY2xlYXJlZCBkb3duJyBmcm9tIHNlcnZpY2Vfam9iczxiciAv PsKgwqDCoHdoZXJlIHNqX2RhdGUgJmx0OyBDVVJSRU5UX0RBVEUgYW5kIHNqX3NyX2lkID0gMTAg YW5kIHNqX3N0YXRlICZsdDsgOTA7PGJyIC8+SU5TRVJUIDAgMDxiciAvPmdvb2xlPSMgdXBkYXRl IHNlcnZpY2Vfam9icyBzZXQgc2pfc3RhdGU9OTAgd2hlcmUgc2pfZGF0ZSAmbHQ7IENVUlJFTlRf REFURSBhbmQ8YnIgLz5zal9zcl9pZCA9IDEwIGFuZCBzal9zdGF0ZSAmbHQ7IDkwOzxiciAvPlVQ REFURSAwPGJyIC8+Z29vbGU9IyBzZWxlY3Qgc2VydmljZV9jbGVhcmRvd24oMTAsMjUpOzxiciAv PkVSUk9SOiBxdWVyeSBoYXMgbm8gZGVzdGluYXRpb24gZm9yIHJlc3VsdCBkYXRhPGJyIC8+Q09O VEVYVDogUEwvcGdTUUwgZnVuY3Rpb24gInNlcnZpY2VfY2xlYXJkb3duIiBsaW5lIDExIGF0IFNR TCBzdGF0ZW1lbnQ8YnIgLz5nb29sZT0jPGJyIC8+wqA8L3A+PC9ibG9ja3F1b3RlPg==