plpgsql

相关标签：javascript jquery android 多少钱 iPhone

How to convert this T-SQL code to PostgreSQL / plpgsql

I need to convert the following tsql function code into a plpgsql function and I have absolutely no idea how:[详细]

2023-01-09 04:00 分类：问答
How can I send some http request from postgresql function or trigger

I need to send data 开发者_如何学Pythonvia http protocol (GET or POST request) from the function or trigger.[详细]

2023-01-08 12:17 分类：问答
postgresql: using NEW.* in dynamic command for EXECUTE

i try to create a plpgsql trigger for postgresql 8.3 which automatically partitions a table on before insert[详细]

2023-01-07 19:43 分类：问答
Psycopg2 callproc and sql parameters

I got some S开发者_StackOverflow社区QL function CREATE OR REPLACE FUNCTION tools.update_company(IN company_id integer, OUT value integer)[详细]

2023-01-06 06:14 分类：问答
Convert fields to timestamp for comparison

I have a Postres database and want to compare two timestamp fields. Basic query: select t1.valu1, t1.valu2 from table1 as t1 where t1.valu1 == t1.valu2[详细]

2023-01-05 22:53 分类：问答
Create a function with an argument as a subselect

I\'d like to create a function for select and changed me data CREATE OR REPLACE FUNCTION PublicatedTask( argument ) RETURNS SETOF task AS $$DECLARE[详细]

2023-01-05 14:46 分类：问答
Python DataError coming from stored procedure, but no error when run manually

I am getting this error: DataError: (DataError) invalid input syntax for integer: \"1.50\" CONTEXT: PL/pgSQL function \"sp_aggregate_cart\" line 82[详细]

2023-01-05 03:49 分类：问答
Remove redundant function call for column and column's count

Problem In the following query, plr_stations is called twice: once to limit the WHERE clause; and once to count the number of results it returned.[详细]

2023-01-05 01:07 分类：问答
Determining the column name passed to a Pg function

I have a PL/pgsql function like so CREATE OR REPLACE FUNCTION foo(colname TEXT, col INT) RETURNS REAL AS $$[详细]

2023-01-04 17:05 分类：问答
How can I use "IF statements" in a postgres trigger

I have a trigger function that I only want to fire on certain instances of INSERTS, in this case, if do_backup = true. If it fires in all instances, I get an infinite loop. The logic seems pretty simp[详细]

2023-01-03 22:21 分类：问答