StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
5877003
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
8
CommunityOwnedDate
CreationDate
2011-05-03T23:46:34.423
FavoriteCount
0
LastActivityDate
2011-05-06T01:37:02.053
LastEditDate
2011-05-06T01:37:02.053
LastEditorUserId
596329
OwnerUserId
596329
ParentId
5876989
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
There are two issues going on, here. You used <a href="http://docs.python.org/library/re.html#re.MatchObject.group" rel="nofollow">group()</a> without specifying a group, and I can tell you are getting confused between the behavior of regular expressions with an explicitly parenthesized group and without a parenthesized group. This behavior without parentheses that you are observing is just a shortcut that Python provides, and you need to read the documentation on <a href="http://docs.python.org/library/re.html#re.MatchObject.group" rel="nofollow">group()</a> to understand it fully. <pre><code>>>> import re >>> string = "baaa" >>> >>> # Here you're searching for one or more `a`s until the end of the line. >>> pattern = re.search(r"a+$", string) >>> pattern.group() 'aaa' >>> >>> # This means the same thing as above, since the presence of the `$` >>> # cancels out any meaning that the `?` might have. >>> pattern = re.search(r"a+?$", string) >>> pattern.group() 'aaa' >>> >>> # Here you remove the `$`, so it matches the least amount of `a` it can. >>> pattern = re.search(r"a+?", string) >>> pattern.group() 'a' </code></pre> Bottom line is that the string <code>a+?</code> matches one <code>a</code>, period. However, <code>a+?$</code> matches <code>a</code>'s until the end of the line. Note that without explicit grouping, you'll have a hard time getting the <code>?</code> to mean anything at all, ever. In general, it's better to be explicit about what you're grouping with parentheses, anyway. Let me give you an example with explicit groups. <pre><code>>>> # This is close to the example pattern with `a+?$` and therefore `a+$`. >>> # It matches `a`s until the end of the line. Again the `?` can't do anything. >>> pattern = re.search(r"(a+?)$", string) >>> pattern.group(1) 'aaa' >>> >>> # In order to get the `?` to work, you need something else in your pattern >>> # and outside your group that can be matched that will allow the selection >>> # of `a`s to be lazy. # In this case, the `.*` is greedy and will gobble up >>> # everything that the lazy `a+?` doesn't want to. >>> pattern = re.search(r"(a+?).*$", string) >>> pattern.group(1) 'a' </code></pre> Edit: Removed text related to old versions of the question.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POWhy is the minimal (non-greedy) match affected by the end of string character '$'?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USarussell84
UserOwnerUserId
1. USarussell84
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.