Search Postgresql Archives

Re: Sort question - Fractions, Metric etc

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Yep,

I provide the UI for the user to select the vendor supplied unit value from the list.

I don't want anyone entering (manually) any value, they must select from my list (fed from a PG table).

(and since some units don't translate exactly, they pick the one that is closest).

It's Tile (floor, shower etc), not the tightest tolerance of dimensions, so it's not catastrophic if it's off

a 32nd or so.

cheers





On 8/14/2021 1:43 PM, Adrian Klaver wrote:
On 8/14/21 1:24 PM, Bret Stern wrote:
Here's the clip of the UI. The user selects whatever value the vendor provides for unit thickness. The data entry

So the vendors supply the measurements in all the various units for a given item?


people aren't comfortable converting.

At this point the sort_order column managed to do the trick....but going forward on my next

application, I can see a different approach.

Are you suggesting a function like this shellsort used with an array.







[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux