Ask HN: What's the best self hosted/local alternative to GPT-4?

Re:Ask HN: What's the best self hosted/local alternative to ... by ivanhoe on Wednesday May 31, 2023 @11:14AM (#36139302)

> GPT-4: PostgreSQL: SELECT STRING_AGG(columnName, ', ') FROM tableName;

Well, you asked for sql and ansi sql function is listagg(), so technically this is not the right answer - and definitely a completely useless one for mysql or oracle users.

[ Parent | on HN ]

Re:Ask HN: What's the best self hosted/local alternative to ... by discordance on Wednesday May 31, 2023 @11:58AM (#36139846)

"Thanks ChatGPT. Could you please write that for MySQL and additionally for Oracle?"

MySQL: SELECT GROUP_CONCAT(columnName SEPARATOR ', ') FROM tableName;

Oracle: SELECT LISTAGG(columnName, ', ') WITHIN GROUP (ORDER BY columnName) FROM tableName;

I mean, it's not a big deal.. you just give have to give it a little nudge.

[ Parent | on HN ]