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)



Subject: IN Statements
Download (untitled) / with headers
text/plain 372b
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.
From: rod.taylor [...] gmail.com
Download (untitled) / with headers
text/plain 566b
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.


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.