plpgsql-CodePudding

Tags > plpgsql

09-15OSSet concatenated string as a application_name
09-10databasePostgreSQL - How to find length of sub array
09-09OShow to write select statement inside if in PostgreSQL
08-31MobileUser-defined function for string to date conversion
08-24Software engineeringHow to simplify procedure using IF statements inside where clause in PL/pgSQL
08-20Nethow to assign variable to unnest in PostgreSQL
08-19Back-endHow do I use the conditional WHERE date >= current_date - INTERVAL '{time interval)' us
08-19Software designPosgreSQL function passing parameters by name
08-18front endIs it good idea to reuse auto-generated ids? [PostgreSQL]
08-16EnterpriseImport CSV parts from S3 into RDS Aurora PostgresSQL
08-15OShow to make sure that a jsonb object is not an encoded string?
08-09Software designWhy is <NULL> being returned by this PL/pgSQL function?
08-03Software engineeringNeed help improving effienciency in a function relative to deletion
07-28NetPostgres function returning a string from a select statement
07-19BlockchainPostgres SQL | IF ELSE | HOW TO
07-15Enterpriseplpgsql: change order of update
07-15Software engineeringplpgsql: Cast 'new' record for insert statement
07-12EnterpriseHow to call function with type cid in postgres
07-11BlockchainC-like compound assignment operator in Postgresql
07-08Software engineeringDifference between aggregate and function in PostgreSQL
06-30OSHow to check current database inside pl\pgsql script?
06-30databaseHow to return multiple values from one function postgres
06-30MobileIs there a way to declare an array variable which accepts a cursor ROWTYPE as its datatype in Postgr
06-25Back-endWhy are TRIM and SUBSTRING not working in this PL/pgSQL function?
06-24EnterpriseIs there a way to get a random element out of a cursor in PL/PgSQL?
06-18Back-endHow to loop through columns within a row
06-18Back-endPostgres SELECT that doesn't work with the first function call
06-15Netmalformed array literal when convetring jsonb array of jsonb items to postgres array of jsonb by jso
06-12Software engineeringIs logic blocks in stored procedure/server function run sequentially or run parallel like in CTE?
06-06Software engineeringRollback outer function if nested function throws a (trapped!) exception
06-04otherPostgres: calling function with text[] param fails with array literal
05-28Software engineeringPostgreSQL: Iterating over array of text and executing SQL
05-28MobileHow determine if range list contains specified integer
05-23otherCreate a custom aggregate function in postgresql
05-21otherERROR: syntax error at or near "END" when creating function
05-21front endPostgresql sequential add/remove reduction operation
05-21front endConcatenation with variable in function gives an error
05-19front endin plpgsql, how would i create table rows from a loop
05-18Software designIn pl/pgsql, is there a way to RAISE calculations?
05-17databaseCan I use the same variable in different positions in dynamic SQL query in PostgreSQL

119 1 2 3 Next Last