Hi,
I have simplified the case and tried to look from a list of json items
(please see test table content). I think I have managed to unpack values in
such a way that also partial matching is possible. However, the end result
has two "value" named columns even if I have tried to rename them.
How
Hi,
Thank you for reply.
I think I need to do some more research of means to implement searching for
json databases.
I'll look the module.
Thanks
2015-11-03 18:43 GMT+02:00 Merlin Moncure :
> On Tue, Nov 3, 2015 at 9:57 AM, Vick Khera wrote:
> >
> > On Tue, Nov 3, 20
m trying to create a query which looks values in any field in JSON, "a"
and "b" in this case (without knowing the names "a" and "b").
Thanks
2015-11-03 0:56 GMT+02:00 Jason O'Donnell :
> Sami,
>
> What version of postgres are you usin
Hi,
I have a database with jsonb type of columns. Colums contain complex json
structures. I would like to get all rows which contain a json where any of
json's values matches to a given string (like %hello%).
How to create a postgre sql query to do this?
I guess postgre should traverse though ea
Postgres?
I am using the PG 8.2.3 WinXP installer downloaded on 07 Feb 2007
Thanks
Sami
On 4/10/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
samı escribió:
> Hi
>
> I am using PostgreSQL 8.2.3 on WindowsXP
>
> I am using the PL/Perl regression tests located here:
>
&g
-h localhost -p 5432 -U postgres - W password
Database "password" will be permanently removed.
Are you sure? (y/n) n
Is this acceptable/normail behavior?
Thanks
Sami
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
> The insert statement executed from php is:
> >
> > $otsikko = "Insert testi";
> > $teksti = "Koeteksti 1";
> >
> > $sqllause = "INSERT INTO jutut (otsikko,teksti) VALUES ('";
> > $sqllause = $sqllause . $otsikko . "','" . $teksti . "');";
>
> Have you tried without the ";"?
Hi, I'm trying to insert data from a php-page. The connection is open and
select-functions work perfectly. The problem is that an insert will - as far
as I know - insert the data and then immediately erase it.
The insert statement executed from php is:
$otsikko = "Insert testi";
$tekst
