Postgres Pro
Downloads
Home   >   mailing lists

Re: Array value from table as parameter - Mailing list pgsql-general

From David G. Johnston
Subject Re: Array value from table as parameter
Date
Msg-id CAKFQuwYr2AtGA3Y17d92wAFAnBOqS0SNw+o=UXLmHZXNuMMR2g@mail.gmail.com
Whole thread Raw
In response to Array value from table as parameter  (Aislan Luiz Wendling <aislanluiz@hotmail.com>)
List pgsql-general
Tree view
On Wed, Jul 20, 2016 at 1:17 PM, Aislan Luiz Wendling <aislanluiz@hotmail.com> wrote:

it doesn't work, as the value comes like this: {"xxxxx","yyyyy"}


​SELECT '{"xxxxx","yyyyy"}'::text[] = array['xxxxx','yyyyy']::text[]; -- TRUE

David J.

pgsql-general by date:

Previous
From: Pavel Suderevsky
Date:
Subject: 9.5: pg_stat_statement and pgbench execution time discrepancies
Next
From: Andrew Geery
Date:
Subject: gin index operator class functions in sql?