Blue

^^

That's fine then

Was there a meta post I missed suggesting to do this?

@emanresuA I'm not sure why you felt the need to edit about 10 of my posts to remove the non-competing header from them. I guess it's fine but also I think those posts were fine as is

Oh, congrats^^

Mine's the same minus 100

Hey

I like Pycharm

unicode-8-on-side

Or just ∞

Rip SO

Is SO dead?

And RIP site analytics

Everything looks green

This looks new as well: codegolf.stackexchange.com/tools/question-close-stats

Is there a way of fetching anonymous votes/feedback from questions/answers as we're looking at them?

Good to know I'm not completely blind then^^

There's so much random badly labelled stuff behind the site tools permission

Well the languages used has definitely changed a bit

I think there's already an image out there that was done a while back

Well yeah

A bit of SQL?

And most languages would be near 0

As a answer percentage thing it could look interesting

It would be cool if it included every language that had that format

Is anyone good with elasticsearch? I'm getting rather confused with it

Oh, it appears to work, though the online tester was odd

I'm effectively trying to implement backslash escaping

That looks like it still doesn't catch the (

Is anyone good at regex? I'm trying to write a regex that doesn't match strings that contain ( unless it's preceeded by \ So \( matches but ( doesn't.

I've not used any yet

lol

I don't like really long queries now :P

@Veskah I tried to do away with the select but then the order by got in the way - I've solved it now in a hacky way

But SELECT MAX(LENGTH(i.ProductID)) FROM i doesn't see i as a valid table

SELECT
  RPAD(i.ProductID||',', 2+(SELECT MAX(LENGTH(i.ProductID)) FROM i)) ||
  RPAD(i.ProductDesc||',', 2+(SELECT MAX(LENGTH(i.ProductDesc)) FROM i)) ||
  '£'||i.TotalValueSold padded
FROM
  (
    SELECT
      'ProductID' as ProductID,
      'ProductDesc' as ProductDesc,
      'TotalValueSold' as TotalValueSold from table(sys.odcivarchar2list(1))
    UNION ALL
    SELECT
      TO_CHAR(ProductID),
      ProductDesc,
      TO_CHAR(TotalValueSold)
    FROM ProductInfoFinancial
  ) i
GROUP BY i.ProductID, i.PRODUCTDESC, i.TotalValueSold

What I want (full)

That depends on the number of results

It might be implementation dependent

It does work because I was using it before I added the FROM

?

It was part of a more complicated thing involving functions, but I worked out I didn't actually need the inner select

i doesn't appear to be in scope in the inner section

The context is some massive awful megaquery but that's the shortest example I can find where it's not working

SELECT
  (SELECT i.attr FROM i)
FROM (SELECT * FROM RealTable) i

Before I head over to SO, I'm confused about some SQL and how to properly write it such that it's not invalid.

And chat seems much quieter than it was before