Search code examples
How to give select query a name in Postgres...


postgresqlprepared-statementcommon-table-expressionsql-viewsql-function

Read More
Correctly escape a trailing backslash in a string within XML to JSON function?...


sqlsql-serversql-function

Read More
Backticks not right in sql string...


phpcodeigniterquery-buildersql-functionquoting

Read More
Grouping repeated XML elements into JSON arrays...


sqlsql-serversql-function

Read More
SQL date format convert? [dd.mm.yy to YYYY-MM-DD]...


mysqlsqldateformatsql-function

Read More
Entity Framework Core equivalent of getting the int result similarly to the .ExecuteScalar("SEL...


c#entity-framework-coreasp.net-core-webapisql-function

Read More
How to make a CodeIgniter UPDATE query using set() with a value of NOW()...


phpcodeignitersql-updatequery-buildersql-function

Read More
CodeIgniter where() parameter containing SQL function is being incorrectly quoted...


phpmysqlcodeigniterwhere-clausesql-function

Read More
How to write a SQL function within CodeIgniter's where() method...


phpmysqlcodeigniteractiverecordsql-function

Read More
CodeIgniter is not correctly applying identifier quotes in CONCAT_WS() expressions...


phpcodeigniteractiverecordescapingsql-function

Read More
Transposing the row into a column header and other as column value in Redshift SQL...


sqlamazon-web-servicesamazon-redshiftsql-function

Read More
Calling GROUP_CONCAT() within CodeIgniter's active record renders an invalid query...


phpcodeigniteractiverecordescapingsql-function

Read More
Using GROUP_CONCAT() in the SELECT clause of a CodeIgniter active record script creates an invalid q...


phpcodeigniteractiverecordescapingsql-function

Read More
CodeIgniter's active record using CONCAT_WS() in select() renders an invalid query...


phpcodeigniteractiverecordescapingsql-function

Read More
Convert query with SQL function calls in SELECT clause to CodeIgniter active record...


phpcodeigniterselectactiverecordsql-function

Read More
Registering a SQL function with JPA and Hibernate...


javaspringhibernatesql-functiondialect

Read More
Msg 178, Level 15, State 1, Line 8 A RETURN statement with a return value cannot be used in this con...


sqlsql-serversql-server-2008t-sqlsql-function

Read More
Table-Valued Function(TVF) vs. View...


sql-serversql-viewsql-function

Read More
Passing array to WHERE IN on multiple columns in a function...


sqlarrayspostgresqlplpgsqlsql-function

Read More
PostgreSQL function has syntax error at IF. Why?...


sqlpostgresqlplpgsqlrdbmssql-function

Read More
Using function result in WHERE clause in PostgreSQL...


postgresqlselectwhere-clausesql-function

Read More
Reading Oracle boolean filed dbms_utility.is_cluster_database in statement...


oracle-databaseplsqloracle11gsql-function

Read More
Function vs. Stored Procedure in SQL Server...


sqlsql-servert-sqlstored-proceduressql-function

Read More
Set schema for objects referred to in postgres functions to same as the function itself...


sqlpostgresqlsql-function

Read More
Memoizable functions - Snowflake...


snowflake-cloud-data-platformsql-function

Read More
Why is the explicit table name necessary in this Postgres Function?...


postgresqlplpgsqlsql-function

Read More
Check if variable contains x in PostgreSQL function...


regexpostgresqlsql-function

Read More
How do I create a PostgreSQL TRIGGER to automatically calculate columns after INSERT?...


postgresqlsqlitetriggerssql-insertsql-function

Read More
MySQL Cursor jumps out before it reaches the end...


mysqlsqlproceduresql-function

Read More
Syntax Error #1064 when using MariaDB JSON_REPLACE function...


syntaxmariadbsql-function

Read More
BackNext