Recent questions tagged plpgsql

0 votes

333 views

1 answer

plpgsql - Dynamically generate columns for crosstab in PostgreSQL

I am trying to create crosstab queries in PostgreSQL such that it automatically generates the crosstab columns instead of ... list of columns ? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

498 views

1 answer

plpgsql - How to convert a text field of chars to json using pl/pgsql?

Need to take a text field such as 'O T D' and convert it to a json output like: "types": [ "O", "T", ... /65910884/how-to-convert-a-text-field-of-chars-to-json-using-pl-pgsql...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

442 views

1 answer

plpgsql - PL/PostgreSQL how to convert a variable into a table name

So I have a function in PostgreSQL that dynamically selects columns from a dynamic table. I got this solution from this post and it ... :$2); $1 is 5 and $2 is 'goals' for example...

asked Feb 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags