Michel Milezzi questions

Michel Milezzi answers

• postgresql undefined json field does not return null as expected
• SQL Argument of LIMIT must not contain variables
• Limit query by count distinct column values
• postgresql weird invalid input syntax for type numeric: "" while value is not an empty varchar
• Postgres: how to grant an user to add more users to a group
• How to do an SQL UPDATE based on INSERT RETURNING id in Postgres?
• Using function result in WHERE clause in PostgreSQL
• Postgres Creating JSON Object from Aggregated Rows
• Postgres query result to json object
• How to obtain primary key value in trigger function if primary key column name is unknown?