question about array indexing

2019-11-04 Thread Szymon Lipiński
Hey, I'm wondering if this isn't a bug somewhere in the parser. I had to add additional parenthesis around the regexp_split_to_array. $ with x as (select 'a b c' a) select regexp_split_to_array(a, ' ') from x; regexp_split_to_array --- {a,b,c} (1 row) $ with x as (sele

Re: SQl help to build a result with custom aliased bool column

2019-04-08 Thread Szymon Lipiński
Hey, you could just use SELECT features.id, features.name, company_features.company_id = 1 as active regards, Szymon On Mon, 8 Apr 2019 at 09:55, Arup Rakshit wrote: > I have 2 tables Company and Feature. They are connected via a join table > called CompanyFeature. I wa

Re: bug in autovacuum_analyze_scale_factor meta data

2018-10-31 Thread Szymon Lipiński
Yep, I messed a couple of options, I'm sorry. regards, Szymon Lipiński On Wed, 31 Oct 2018 at 15:07, Adrian Klaver wrote: > On 10/31/18 6:58 AM, Szymon Lipiński wrote: > > This is what I have in postgres 10 pg_settings table: and the > > documentation has different descript

bug in autovacuum_analyze_scale_factor meta data

2018-10-31 Thread Szymon Lipiński
ource | default min_val | 0 max_val | 100 enumvals| [NULL] boot_val| 0.1 reset_val | 0.1 sourcefile | [NULL] sourceline | [NULL] pending_restart | f regards, Szymon Lipiński

Re: Code of Conduct plan

2018-06-07 Thread Szymon Lipiński
On Fri, 8 Jun 2018 at 06:01, Gavin Flower wrote: > On 08/06/18 14:21, Christophe Pettus wrote: > >> On Jun 7, 2018, at 02:55, Gavin Flower > wrote: > >> The Americans often seem to act as though most people lived in the USA, > therefore we should all be bound by what they think is correct! > > I

Re: [GENERAL] Multiple key error .

2017-11-23 Thread Szymon Lipiński
> Thanks & Regards, > Brahmeswara Rao J. > Hey, table can have only one primary key. And most probably you already have one. regards, Szymon Lipiński