Re: [GENERAL] PG user group in the Kuala Lumpur area?

On Sun, Jan 18, 2015 at 10:14 PM Torsten Förtsch wrote: > Hi, > > I was looking for a PG user group around KL. I know there is one in > Singapore. As it happens, Chris Travers, the PG contact for Malaysia is > a friend of mine. So, I asked him. He wasn't aware of one either. > However, he very mu

Re: [GENERAL] pg_dump without any SET command in header of output plain text sql file

On Thu, Jul 21, 2016 at 7:14 PM Alex Ignatov wrote: > And what is the options you mentioned about? > I stand corrected. I think the only ones you can avoid are OWNERSHIP and TABLESPACE commands. I think sed would be the best tool here. > Alex Ignatov > Postgres Professional: http://www.postgre

Re: [GENERAL] gin index operator class functions in sql?

Andrew Geery writes: > Is it possible to define functions in SQL (as opposed to C) to do the same > thing -- create an operator class -- for a gin index? Afraid not; several of those APIs are C-specific. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-g

Re: [GENERAL] For storing XML version in our table.

On Wed, Jul 20, 2016 at 3:09 AM, zubair alam wrote: > Hi > How i can store my xml data with their version in postgres database > table. > Works on 9.5...though it doesn't seem to validate the provided value, just stores it. ​SELECT E'\nHi'::xml::text; SELECT E'\nHi'::xml::text; CREATE TA

Re: [GENERAL] 9.5: pg_stat_statement and pgbench execution time discrepancies

Pavel Suderevsky writes: > During performance tests it was mentioned that pgbench common results are > being different from what pg_stat_statements provides. Well, they're not measuring even approximately the same thing, so I'm not sure why that surprises you. pg_stat_statements only measures th

[GENERAL] gin index operator class functions in sql?

For a custom type to be used in a btree index, it is possible to create a function in SQL (as opposed to C) that is used in the create operator class statement to specify how equality is defined. A good example of this is presented inhttp://www.cybertec.at/2013/11/operator-classes-explained/. Is

Re: [GENERAL] Array value from table as parameter

On Wed, Jul 20, 2016 at 1:17 PM, Aislan Luiz Wendling < aislanl...@hotmail.com> wrote: > > it doesn't work, as the value comes like this: {"x","y"} > > ​SELECT '{"x","y"}'::text[] = array['x','y']::text[]; -- TRUE David J.

[GENERAL] 9.5: pg_stat_statement and pgbench execution time discrepancies

Hi, During performance tests it was mentioned that pgbench common results are being different from what pg_stat_statements provides. PostgreSQL version 9.5.3, centos 7.2. First run after pg_stat_extension created and first pgbench run. *pgbench *-c 30 -T 300 -U postgres -P 10 -r -v > statement

[GENERAL] Array value from table as parameter

Hi, I need to pass an array as a parameter in a function, but it is a part of a trigger that get a "new" value. I've tested it like select function_x(1,55,array[['x'],['y']]) orselect function_x(1,55,array[['x','y']]) and it worked. But if I use select functio

[GENERAL] For storing XML version in our table.

Hi How i can store my xml data with their version in postgres database table.

Re: [GENERAL] pg_dump without any SET command in header of output plain text sql file

And what is the options you mentioned about? Alex Ignatov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company On 20.07.2016 21:02, Sameer Kumar wrote: On Thu, 21 Jul 2016, 1:17 a.m. Alex Ignatov, > wrote: Hello everyone! I