LWN.net Logo

HStore syntax

HStore syntax

Posted Sep 21, 2010 21:29 UTC (Tue) by dskoll (subscriber, #1630)
In reply to: HStore syntax by andresfreund
Parent article: PostgreSQL 9.0 arrives with many new features

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...


(Log in to post comments)

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'
WHERE user_id = 5;

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.

Copyright © 2013, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds