All we need is an easy explanation of the problem, so here it is. I have this function: CREATE OR REPLACE FUNCTION laborable_day(dtDateTime TIMESTAMP WITH TIME ZONE) RETURNS TIMESTAMP WITH…
All we need is an easy explanation of the problem, so here it is. I was reading about the CONCAT() function, and I noticed this: mysql> SELECT CONCAT(14.3); -> '14.3'…
All we need is an easy explanation of the problem, so here it is. I have a query that has an inline function: with function with_f(p_text in varchar2) return varchar2…
All we need is an easy explanation of the problem, so here it is. I am in the process of restructurizing and unifying a large database in PostgreSQL. One part…
All we need is an easy explanation of the problem, so here it is. Take the following queries: DECLARE @X VARCHAR(200) = '1,2,3,4' SELECT *, dbo.aUserDefinedScalarFunction(4) AS ScalarValue FROM MyTable…
All we need is an easy explanation of the problem, so here it is. I'm fairly new to database administration and PostgreSQL, and there's some things I'm not familiar with,…
All we need is an easy explanation of the problem, so here it is. If I have a function in PostgreSQL, I can validate its arguments (eg. a username argument)…
All we need is an easy explanation of the problem, so here it is. Postgres 12+ supports generated columns: https://www.postgresql.org/docs/current/ddl-generated-columns.html From the docs, the syntax seems limited - it forces…
All we need is an easy explanation of the problem, so here it is. Setup For this demo, I'm using the 2013 version of the Stack Overflow database, and SQL…
All we need is an easy explanation of the problem, so here it is. Currently getting an error about type casts, HINT: Could not choose a best candidate function. You…