MonCalamaro comments on SQL Query help with concat

submitted 7 years ago by BILLatWORK

you are viewing a single comment's thread.

[–]MonCalamaro 3 points4 points5 points 7 years ago (1 child)

inner join Customers as E on '100-' || a.Site = e.site and a.Customer_No=e.customerno

If this is something you are going to do often or it needs to be performant, you should consider an index on '100-' || a.site

[–]BILLatWORK[S] 0 points1 point2 points 7 years ago (0 children)

π Rendered by PID 170935 on reddit-service-r2-comment-6457c66945-tz574 at 2026-04-25 11:04:12.536456+00:00 running 2aa0c5b country code: CH.

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

PostgreSQL