I'm trying to return TEXT[] type from my_func() with a RETURN QUERY EXECUTE and VALUES statement. But calling my_func() which has " in '' got the error as shown below: CREATE FUNCTION my_func() RETURNS SETOF TEXT[] AS $$ BEGIN --…
I am developing a game like app with an leaderboard and want the leaderboard to have this features: Show Top 100 Show Top 100 Monthly, Weekly, Daily Show Trends next to every User (if the user moved up on the…
Is it not possible to store data to JSON file ? I mean I want to store the questions from the UI. I haven't started my database concepts yet. I know it is far far efficient to use Database. Can…
Refer this! I was creating a database and got this error i tried to uninstall and then reinstall postgresql-16 and pgadmin4 but it didn't work for me! It creates a database but gives this error i am worried that what…
I am implementing a leaderboard for my game and since it needs to be fast and run-time I am planning to use Redis. I haven't use Redis before so I am confused about one thing. As far as I know…
I tried to declare the local variable value with RECORD[] type in a DO statement as shown below: DO $$ DECLARE value RECORD[]; BEGIN END $$; But, I got the error below: ERROR: variable "value" has pseudo-type record[] I referred…
PostgreSQL has SETOF <sometype> type according to the doc and SETOF <sometype> type is used in a function as shown below: -- ↓ ↓ ↓ Here ↓ ↓ ↓ CREATE FUNCTION my_func() RETURNS SETOF <sometype> ... Now, I want to…
I'm fairly new to SQL and have an exercise I'm trying to figure out how to translate a YEAR column into the following conditions: YEAR is 1 if student is registered in courses 1009 & 1029 YEAR is 2 if…
My question is that how many times will COUNT(*) be called for each group? Three times or just one time? If the answer is three times, how can i optimize it. SELECT COUNT(*) AS num1, COUNT(*) / 10 AS num2,…
I need to fetch the string For reference 110_112_120_122_130_132_140_143_149_151_154_160_162_165_171_173_194_215_236_257_278_299 use this as a subjects I am using the below query select * from table_name where subjects like '%_21_%' ; which is not showing desired result. Note - 21 can come…