StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
17174446
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-06-18T16:42:42.617
FavoriteCount
0
LastActivityDate
2014-11-22T09:27:21.300
LastEditDate
2014-11-22T09:27:21.300
LastEditorUserId
222893
OwnerUserId
1153747
ParentId
1604305
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
Answer: <code>a.τwτ</code>, but you have to install <a href="https://rubygems.org/gems/pyper" rel="nofollow">Pyper</a> first... Pyper intro: Do you know Lispy <code>car</code> and <code>cdr</code> returning "first" and "rest" of the array? Just for the needs like yours, I made an extension of this Lispy mechanism. It's called <code>pyper</code>, and it allows you to access also 2nd, rest from 2nd, 3rd, rest from 3d, and also last, everything except last etc. That wouldn't be much to write about, but it also allows letter composition, just like <code>caar</code>, <code>cadr</code>, <code>cdadar</code> etc. known from Lisp: <pre><code># First, gem install pyper require 'pyper' include Pyper a = %w/lorem ipsum dolor sit amet/ # To avoid confusion with other methods, and also because it resembles a rain gutter, # Greek letter τ is used to delimit Pyper methods: a.τaτ #=> "lorem" a.τdτ #=> ["ipsum", "dolor", "sit", "amet"] a.τbτ #=> "ipsum" a.τeτ #=> ["dolor", "sit", "amet"] a.τcτ #=> "dolor" (3rd) a.τzτ #=> "amet" (last) a.τyτ #=> "sit" (2nd from the end) a.τxτ #=> "dolor" (3rd from the end) </code></pre> and finally, the answer to your question: <pre><code>a.τwτ #=> ["lorem", "ipsum", "dolor", "sit"] (all except last) </code></pre> There is more: <pre><code>a.τuτ #=> ["lorem", "ipsum", "dolor"] (all except last 2) a.τ1τ #=> ["lorem", "ipsum"] (first 2) a.τ8τ #=> (last 2) a.τ7τ #=> (last 3) </code></pre> Compositions: <pre><code>a.τwydτ #=> "olor" (all except 1st letter of the last word of all-except-last array) </code></pre> There are also more command characters than just <code>a..f</code>, <code>u..z</code> and <code>0..9</code>, most notably <code>m</code>, meaning map: <pre><code>a.τwmbτ #=> ["o", "p", "o", "i"] (second letters of all-except-last array) </code></pre> But other command characters are too hot and not very easy to use at the moment.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POAll but last element of Ruby array
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USweakish
UserOwnerUserId
1. USBoris Stitnicky
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
 VTDownMod
CommentsPostId
1. This table or related slice is empty.

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.