Skip Menu |

This queue is for tickets about the SQL-Beautify CPAN distribution.

Report information
The Basics
Id: 89268
Status: new
Priority: 0/
Queue: SQL-Beautify
People
Owner: Nobody in particular
Requestors: rod.taylor [...] gmail.com
Cc:
AdminCc:
Bug Information
Severity: Wishlist
Broken in: 0.04
Fixed in: (no value)

History Show all quoted text
  Sat Oct 05 16:01:30 2013 rod.taylor [...] gmail.com - Ticket created
Subject: IN Statements
This type of structure "= ANY(?)" is common for creating IN type statements in PG because you can pass it a simple array. Right now it breaks on the open/close brackets and indents those lines even when the sole content is a single ?. foo = ANY( ? ) Is it possible to not format brackets when their contents are small? Small might be defined as 10 characters or less.
  Sat Oct 05 16:30:58 2013 rod.taylor [...] gmail.com - Correspondence added
From: rod.taylor [...] gmail.com
On Sat Oct 05 16:01:30 2013, rtaylor wrote: Show quoted text
> This type of structure "= ANY(?)" is common for creating IN type > statements in PG because you can pass it a simple array. > > Right now it breaks on the open/close brackets and indents those lines > even when the sole content is a single ?.
SQL Array positions have a similar problem: "array_column[1][1].value = ?" Becomes: "array_column [ 1 ] [ 2 ].value = ?" That's an excessive amount of whitespace. Square brackets only have a limited number of meanings in SQL and specifying array position is the main one.