Re: update without SET ?
| От | Michael Moore |
|---|---|
| Тема | Re: update without SET ? |
| Дата | |
| Msg-id | CACpWLjNLEDtgU0tps0s84w3GtvbRb9Mv27LA+5Y3mTM=zajeHQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: update without SET ? ("David G. Johnston" <david.g.johnston@gmail.com>) |
| Список | pgsql-sql |
Just re-ran the query I provided on the tablemytest 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:
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 tablemytest 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 по дате отправления: