SELECT DISTINCT ON COLUMN

[DevX86]

Attempting to-do a

SELECT 
    COUNT(DISTINCT column_name),
    another_column,
    another_column
...

Is this currently possible @go-jet ? I saw SELECT(table.Table.ColumnName)).DISTINCT() But that wouldn't work in this scenario.

[go-jet]

Currently, this is only possible with raw expressions:

s := SELECT(
	Raw("COUNT(DISTINCT(table.column))")).AS("alias")
FROM(table)

[DevX86]

Seems to work, that's a pretty cool way to implement things until we have it typed as we don't have to make the entire statement raw, just the part that's unique.

[go-jet]

Aggregate DISTINCT operator included in Release 2.7.0.
Sample usage:

jet/tests/postgres/select_test.go

Lines 1195 to 1203 in 3e802f8

	stmt := SELECT(
	Payment.CustomerID,
	COUNT(DISTINCT(Payment.Amount)).AS("distinct.count"),
	SUM(DISTINCT(Payment.Amount)).AS("distinct.sum"),
	AVG(DISTINCT(Payment.Amount)).AS("distinct.avg"),
	MIN(DISTINCT(Payment.PaymentDate)).AS("distinct.first_payment_date"),
	MAX(DISTINCT(Payment.PaymentDate)).AS("distinct.last_payment_date"),
	).FROM(