Postgres Pro
Downloads
Home   >   mailing lists

Re: update without SET ? - Mailing list pgsql-sql

From Michael Moore
Subject Re: update without SET ?
Date
Msg-id CACpWLjNLEDtgU0tps0s84w3GtvbRb9Mv27LA+5Y3mTM=zajeHQ@mail.gmail.com
Whole thread Raw
In response to Re: update without SET ?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-sql
Tree view
Just re-ran the query I provided on the table​
 
​mytest with inserted record you provided above and it worked fine.  Query executed using psql.
You are correct, no problem using psql, it must have been a pgAdmin III problem.
But I have no clue what you mean by: 'att' ? 'attrib' = true; SELECT 'att' ? 'attrib' doesn't even execute and ​the existence operator only considers exact matches.
I have now leaned what the ? operator does. So, no problem here.
P.S. List convention is to either inline or bottom-post.
I hope this is correct. 

Again, thanks so much, have a great day.

Mike 
 

On Thu, Feb 4, 2016 at 8:31 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Thu, Feb 4, 2016 at 9:19 AM, Michael Moore <michaeljmoore@gmail.com> wrote:

Also, was just thinking that two columns with names of say: attrib and att would cause a problem if att was NOT in the JSON and attrib was in,  because: 'att' ? 'attrib' = true. I should be able to clean this up if indeed it is a problem at all. Have not tested it yet.

​Just re-ran the query I provided on the table​
 
​mytest with inserted record you provided above and it worked fine.  Query executed using psql.

But I have no clue what you mean by: 'att' ? 'attrib' = true; SELECT 'att' ? 'attrib' doesn't even execute and ​the existence operator only considers exact matches.

​This will work: if you get more errors you will need to supply the complete test case.

David J.

P.S. List convention is to either inline or bottom-post.
​


pgsql-sql by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Create db fails using utility tool
Next
From: Shashank Dutt Jha
Date:
Subject: Re: Create db fails using utility tool