[GENERAL] Problem with updating hstore extension from 9.2 to 9.3

2013-09-25 Thread Murat Kabilov
uot;contrib/hstore/hstore.control" of pg 9.3 is identical to 9.2 one. And there is no file like "hstore--1.1--1.2.sql". Is there a miss of update files for hstore? Thanks in advance. -- Regards Murat Kabilov

[GENERAL] Stored procedure name

2011-08-17 Thread Murat Kabilov
Hi, Is there any way to get current stored procedure name? Best Regards,

[GENERAL] number of not null arguments

2010-11-26 Thread Murat Kabilov
Hello, Is there a function which returns number of not null arguments? SELECT notnull_count(1, 1, NULL, NULL) notnull_count --- 2 SELECT notnull_count(ARRAY[1,2,3], ARRAY[10,20,30], NULL, ARRAY[NULL]) notnull_count --- 3 Thanks -- Murat

[GENERAL] element from an array by its index

2009-07-21 Thread Murat Kabilov
Hello, I would like to know if there is a function that extracts an element by its index from an array?