how can I find out the maximum column values in a table?

[IknowL1f3]

I found how it's done in JS, but there's nothing in C# (or maybe I didn't see it). How can I find the maximum value of a field in a column?

js:
const { data, error } = await supabase
.from('movies')
.select('release_year.max(), release_year.min()')

[acupofjose]

You can do the same thing in the C# client using Select!

The difference is you would need to alias the Selects (release_year.max AS Max), create a Model (that inherits from BaseModel) to hydrate the data into, and then add Column attributes for the aliased Select values ([Column(“Max”)] public int Max { get; set})

[IknowL1f3]

I didn't quite understand you, I have a request to get the number of records: "Console.WriteLine(await supabase.From().Select(x => new object[] { x.Id }).Count(Supabase.Postgrest.Constants.CountType.Exact));", I don't want to find out their number, but the maximum value, how can i do this?

[acupofjose]

One approach would be to model your query so that you can work with the hydrated values like this:

MoviesYearMinMax.cs

[Table("movies")]
public class MoviesYearMinMax : BaseModel 
{  
   [Column("max")] // <--- Mirrors the alias of the "column" from the SELECT statement
   public int Max { get; set; }

   [Column("min")]
   public int Min { get; set; }
}

Then do your query as follows:

const result = await supabase.From<MoviesYearMinMax>() // Note: Model that we're hydrating into
          .Select('release_year.max() as max, release_year.min() as min') // Note: the alias here matches the model
          .Single();