postgresql - How to unnest an array for supply a sequence of arguments? -

-

PostgreSQL 9.2 के साथ काम करता है, 

  SELECT प्रारूप ('% s% s!', 'नमस्ते दुनिया');   
 लेकिन मुझे  
  SELECT स्वरूप ('% s% s!', सरणी ['हैलो', 'विश्व']) की तरह कुछ चाहिए।   
 या, विशेष रूप से, मुझे कुछ  convertToArgs  की आवश्यकता है,  
  SELECT प्रारूप ('% s% s!', ConvertToArgs (सरणी ['हैलो', 'दुनिया']);   
 
 नोट: वास्तविक समस्या सामान्य है, किसी भी संख्या के साथ (सरणी और संगत प्लेसहोल्डर में)  
  चुनें प्रारूप (टेम्पलेट, कन्वर्टटॉअर्स (मान));    
 
 
 इस सुविधा को तर्क दिया जाता है।  
 आप कॉल कर सकते हैं  VARIADIC  कीवर्ड:  
  SELECT प्रारूप ('% s% s!', 'VARIADIC') में शामिल होने पर  VARIADIC  पैरामीटर भी, एक सरणी के साथ। ARRAY ['हैलो', 'विश्व']);   
  संपादित करें : जैसा कि बताया गया है, यह 9.2 में काम नहीं करेगा। इसलिए नहीं क्योंकि  VARIADIC  तर्क कॉल, और न ही  प्रारूप ()  असमर्थित है दस्तावेज़ के अनुसार  concat ,  concat_ws  और  प्रारूप  को इस तरह से नहीं कहा जा सकता (9.3 से पहले - तथ्य के बगल में, वह  pg_get_functiondef < / कोड> यह 9.2 में भी भिन्नतापूर्ण रिपोर्ट करता है) उपयोगकर्ता परिभाषित कार्य  सकते हैं  इस तरह 9.2 में भी कहा जा सकता है।

Comments

Post a Comment

Popular posts from this blog

Pygame memory leak with transform.flip -

-
Today I came across an interesting issue which, by writing a small side scroller, instead of a sprite sheet, I was planning to use because I lacked a good "packer" for making phantom sheets (and honestly with patience and passion as it is only a test project). Anyway, I showed the animation running on the right of 8 PNG (with transparency). I considered it a good idea to prepare the flipped images to run on the left in the consultant, and the frame is not framed when the game is running (Flip actually consumes a lot of CPU like I Was measured). > To get access to the loop, I get the memory leak self.move_l = [# 8 PNG images with transparency to the right] For the self in IMG. Move_l: self.move_r.append (pygame.transform.flip (img, true, false) error traceback: traceback (most recent Call final): The file "D: \ Python 34 \ _Projects \ efg \ efg.py", in line 196, in the & lt; module & gt; main = master program ((1024, 680)) "D: \ Python ...
Read more

python - Writing Greek in matplotlib labels, titles -

-
Image
I'm trying to write some text for labels, shape titles etc. with my plots, but no benefit till now Has not happened . I do not want to print specific characters (I know how to use special characters), I want to write the entire text in Greek (maybe Unicode and text ' ?). , suggesting that I would like to mention that for some reason I can not get matplotlib to cooperate with Tex (using IPython notebook from Anaconda in Ubuntu 14.10) so that there really is an option Will not be the first. I tried loading the Arial font and it loads successfully but again I get square blocks instead of characters. I import matplotlib.font_manager FM PROP = FM Font Properties (fname = '/ usr / share / fonts / truetype / msttcorefonts / Arial.ttf') And then to display the string I u'Î? ? I ?? Î¿Ï ?? ÎμÎ »second ?? μΠ± i ?? I ± i ?? I ?? Used ο किया? ? Î¿Î¼Î¿Î¯Ï ?? I ?? I · I ?? ' . Ariel is considered to be fully presented to Greek and I have used it many times ...
Read more

c# - Call function from DLL -

-
It is well known that you can work in a DLL, referencing DLL and then your main performance Can call functional function I want to know that the reverse route is also possible? So I want to call a function in the main executable from DLL, without actual function which should be called without DLL. Reason: I'm working on a plugins system. Yes, executables can be added as references in your project, you can use them in the same way On which you call functions from referenced DLS
Read more