RE: str_aggr function not wokring

2021-04-08 Thread Patrick FICHE
From: aditya desai Sent: Thursday, April 8, 2021 1:32 PM To: Pgsql Performance Subject: str_aggr function not wokring Hi, I need to combine results of multiple rows in one row. I get below error. Could you please help. Query: select string_agg((select '**' || P.PhaseName || ' - ' || R.Rec

RE: Can we have multiple tablespaces with in a database.

2020-02-21 Thread Patrick FICHE
TABLESPACE TEST_DATA; CREATE INDEX sk_comment ON test1( comment ) TABLESPACE TEST_IDX; Patrick Fiche Database Engineer, Aqsacom Sas. c. 33 6 82 80 69 96 [01-03_AQSA_Main_Corporate_Logo_JPEG_White_Low.jpg]<http://www.aqsacom.com/> From: Daulat Ram Sent: Friday, February 21, 2020 7:23 AM To