sql formatting help for partition by statements  

  

0

Hello Admin,

There is one area where i could not really find a workaround for formatting. Please see below code as an example.

The partition by statement always falls into the next line,  Is there anyway i could just start it right after OVER ( PARTITION BY ) (<---like this). I tried so many different things but with no luck

 

 OVER (
PARTITION BY xyz.id,
xyz.id ROWS BETWEEN unbounded preceding AND unbounded following) AS xyz,
"max"(CASE WHEN zc.xyz = 1 THEN zc.xyz ELSE NULL END::text) OVER (
PARTITION BY xyz.id,
xyz.id ROWS BETWEEN unbounded preceding AND unbounded following) AS xyz,
"max"(CASE WHEN zc.xyz = 1 THEN zc.xyz ELSE NULL END::text) OVER (
PARTITION BY xyz.id,
xyz.id ROWS BETWEEN unbounded preceding AND unbounded following) AS xyz,
"max"(CASE WHEN zc.xyz = 1 THEN zc.xyz ELSE NULL::integer END) OVER (
PARTITION BY xyz.id,
xyz.id ROWS BETWEEN un

Hi, which DB are you working with?

Could you please export your profile and send it to info @ sqlinform.com

Would you mind sending the complete statement by mail?

Regards

Guido

3 Answers
0

Hello Admin,

I just sent the documents you asked for to the email : info@sqlinform.com

Hi Harsha,

thanks for your mail.

I will investigate and try to find a solution. Maybe this week.

Regards

Guido

0

Hello Admin,

Were you able to find a workaround for this?

Thanks!

0

yes 🙂
It will be published with next release.
Do you want a Beta version for testing purpose?

yes sir! Thanks!

Hello Admin,

Any updates on the beta version?

Hi Harsha,
hopefully this weekend 🙂

Your Answer


 
Preview 0 Revisions Saved
Share:

Please Login or Register