Tag: function

Simulating SELECT YEAR(post_date) SQL query using only WP Query

I’m not entirely sure this is possible but I’m completely out of ideas. The task I’m working on requires that I specifically use WP_Query due to constraints of other efficiency plugins my organization uses. Pure and simple, I need a way to simulate the following query using WP_Query: “…

Cant understand my syntax mistake in MySQL CREATE FUNCTION

function mysql sql

This is my code and I can not find the mistake! I am trying to create a function that multiplies a value to de input parameter and returns that result! It should not be that difficult but I am not finding my sintaxt mistake The mistake says: error code 1064 Answer The DECLARE has to be before the code. I

OOTB Oracle IFERROR function to handle rows that cause errors in a query

error-handling function oracle oracle18c sql

In a related post, @MTO provided a custom function for determining what rows cause errors in a query: That custom function works well. In a query, if a function errors-out for a given row, then the custom function flags the row. That lets me find the problem rows and determine what the issue is, instead of th…

How to make mysql function that return from the select result?

function mysql sql

I want to create this function on mySql 8. It will create a sequence number like 00001,00002 i dunno whats wrong with this query but i always got this error. I also tried with this query. but still gave me with the same error. What could go wrong with my function query ? Answer Multiple datatype convertions a…

SQL Custom Function is not returning data as expected by matching to my conditions

date function postgresql sql

I am trying to create this function but null values fail But some of the conditions are not working, specially when I am passing null calls that are not giving expected results are: Expecting above to return (‘REVIEWED’, -2) while I am getting nothing Expecting above to return ( , -2) while I am g…

Error: Returned type unknown at ordinal position 2, but query expects text

function postgresql sql

I created an SQL function in PostgreSQL that returns a table with text values, it is throwing error Function definition: Answer You could try casting the string literals explicitly to text using the double colon operator:

SQL Function has no destination when called

function postgresql sql

I’m getting a success when creating the below function, but when I call it I receive an error stating there is no destination. Answer Language SQL: https://www.postgresql.org/docs/current/xfunc-sql.html language plpgsql: https://www.postgresql.org/docs/current/plpgsql.html Language sql is more easier to…

While loop function union function end

function loops sql sql-server union

I want to loop the code shown below. I would like to use the [getpublicholidays] function for a variable number of years and merge them (union). Unfortunately I don’t know how to use the function in a loop with union. Can someone help? Answer If you are looping for X years, each time you loop to a new y…

autoincrement number function-postgres

auto-increment function postgresql sql

i have a table like this: id person 20 adams 20 george 40 jina 46 rico 80 naya 90 john 90 peter 90 richard i want to find a way to select a new_id starting from 1 and increazing +1 every time id is different. for example i want a select with a result like this: new_id id person 1

User function return query and insert into

function postgresql sql

I trying to make function, that merge where select query return result as value(not table) and insert into that use value from select statement. The function where argument gets from user, and this argument provide into select query on table_foo that return value id where I try set and use in insert into to d…