(column, path string)
| 273 | } |
| 274 | |
| 275 | func (d *postgresDialect) JSONExtractPath(column, path string) string { |
| 276 | parts := strings.Split(path, ".") |
| 277 | return fmt.Sprintf("%s #>> '{%s}'", column, strings.Join(parts, ",")) |
| 278 | } |
| 279 | |
| 280 | func (d *postgresDialect) JSONSet(column, key string) string { |
| 281 | return fmt.Sprintf("jsonb_set(COALESCE(%s, '{}')::jsonb, '{%s}', to_jsonb(?::text))", column, key) |