Parameters
- condition
- A new condition to add.
PgSqlSelectStatement stmt = new PgSqlSelectStatement(); stmt.Columns.Add(new SelectColumn("EMP")); stmt.Columns.Add(new SelectColumn("SAL")); stmt.Tables.Add(new SelectTable("emp")); stmt.AddHavingCondition("SAL > 1000"); //select JOB,SAL from emp having SAL > 1000 PgSqlCommand command = new PgSqlCommand(stmt.ToString());
Dim stmt As New PgSqlSelectStatement stmt.Columns.Add(New SelectColumn("EMP")) stmt.Columns.Add(New SelectColumn("SAL")) stmt.Tables.Add(New SelectTable("emp")) stmt.AddHavingCondition("SAL > 1000") 'select JOB,SAL from emp having SAL > 1000 Dim command As New PgSqlCommand(stmt.ToString)