| |||||||||||||
HStore syntaxHStore syntaxPosted Sep 21, 2010 20:59 UTC (Tue) by andresfreund (subscriber, #69562)In reply to: HStore syntax by epa Parent article: PostgreSQL 9.0 arrives with many new features
It doesn't delete any stored value - the value returned by the select is modified.
If you wanted to modify the stored value you would need an UPDATE...
(Log in to post comments)
HStore syntax Posted Sep 21, 2010 21:29 UTC (Tue) by dskoll (subscriber, #1630) [Link] Josh's example reads Or even delete specific keys: I assume he means: Or even delete specific keys from the return value of SELECT. At least I hope that's what it means...
HStore syntax Posted Sep 21, 2010 21:38 UTC (Tue) by jberkus (subscriber, #55561) [Link]
Actually, that was a paste-o which neither I nor my proofreader caught. The example, of course, should have been:
UPDATE user_profile SET profile = profile - 'Occupation'
HStore syntax Posted Sep 30, 2010 23:57 UTC (Thu) by MattPerry (guest, #46341) [Link]
Can the SELECT statement be removed from the article? Having it there, lined through or not, is still very confusing.
HStore syntax Posted Oct 1, 2010 3:16 UTC (Fri) by jake (editor, #205) [Link]
> Having it there, lined through or not, is still very confusing.
The problem is that folks reading the comments will get confused as well, which is why I left it in but with strike-through. Is it really that unclear that it is a fix?
jake
HStore syntax Posted Oct 1, 2010 18:42 UTC (Fri) by MattPerry (guest, #46341) [Link]
> Is it really that unclear that it is a fix?
Yes, it was. I had no idea what the strike-through was supposed to signify so I ignored it and then spent time wondering why a select and then update would be needed.
> The problem is that folks reading the comments will get confused as well
A better way to handle that is to just reply to the comments in question and mention that you have fixed the problem. Most people will read the article before the comments and struck-through text provides information with no value.
|
|||||||||||||