select * from jsonb_each_text(jsonb)

[boYu07]

I couldn't find a way to assemble the title query string, any suggestion?

[go-jet]

Hi @boYu07 ,
Json functions are not supported currently. Can't think of workaround for this case unless raw statement is used.

[boYu07]

i tried raw statement

func QueryJsonbEachText(tab postgres.Table, column postgres.Column) postgres.Statement {
	quertString := `SELECT key, value FROM $table, jsonb_each_text($column)`
	s := postgres.RawStatement(quertString, postgres.RawArgs{"$table": tab.TableName(), "$column": column.Name()})
	return s
}

func main() {
	column := postgres.StringColumn("test_column") // this is the json column
	tab := postgres.NewTable("", "test_table", "test_table", column)
	s := QueryJsonbEachText(tab, column)
	fmt.Println(s.DebugSql())
}

i expect the query string like this:
SELECT key, value FROM test_table, jsonb_each_text(test_column);
but i got
SELECT key, value FROM 'test_table', jsonb_each_text('test_column');

[go-jet]

There is no need for RawArgs in your case. RawArgs are placeholder parameters for the query, and can't be used for table source.

stmt := postgres.RawStatement(`SELECT key, value FROM test_table, jsonb_each_text(test_column)`)

[boYu07]

I figure it out, thanks.

[go-jet]

With Release v.2.12.0 there is partial support for set returning functions - faq. The whole statement doesn't have to be raw statement.