plpgsql
How to return updated rows from function
i\'m quite new to postgres. i want to create a function (like stored procedure) that updates multiple 开发者_开发知识库rows and selects affected rows.[详细]
2023-01-20 06:05 分类:问答How to pass a record as parameter for PL/pgSQL function?
I keep looking for this answer online but I cannot find it. I am trying to pass one record over a PL/pgSQL function. I tried it in two ways.[详细]
2023-01-19 05:19 分类:问答What is the equivalent of PL/SQL %NOTFOUND in PL/pgSQL?
Everything\'s in the title. I am Looping on a cursor and would like to have the EXIT WHEN curs%NOTFOUND[详细]
2023-01-19 02:58 分类:问答Query error while working with PL/pgSQL arrays
I have this function: create or replace function insert_aereo( aereo_type[] ) returns text as $$ begin return \'ok\';[详细]
2023-01-16 06:36 分类:问答Is it possible to use variables to access columns of records in postgresql trigger
I have a trigger to update my timestamps for each table. I use the following function: CREATE OR REPLACE FUNCTION update_timstamp_table0() RETURNS TRIGGER AS[详细]
2023-01-16 05:53 分类:问答Shredding XML in postgresql
In SQL Server 2005\'s T-SQL language I can shred XML value the following 开发者_JAVA百科way: SELECT[详细]
2023-01-14 19:23 分类:问答how to convert int to time in a pl/pgsql function
I would like to convert a given date and integer to a timestamp in a pl/pgsql function. i\'ve never done anyt开发者_如何学运维hing with pl/pgsql before, so i\'m somewhat at a loss.[详细]
2023-01-13 10:53 分类:问答Postgres, plpgsql: Is there a way to connect to other DB from inside of a stored procedure?
I have two DB\'s one is f开发者_运维知识库eed by filtered data from another, now i\'m using perl script witch executes query on foreign DB, stores a result in a csv file, and loads it to local DB usin[详细]
2023-01-12 14:05 分类:问答PSQL row update using NEW statment
since it is possible to do: INSERT INTO some_table VALUES (NEW.*) in pl/pgsql can we do somethin开发者_StackOverflow社区g similar but for UPDATE clause using NEW ? I mean i want to[详细]
2023-01-11 22:24 分类:问答PostgreSQL SQL or PL/pgSQL query for traversing a directed graph and returning all edges found
I\'m not particularly accustomed to generating complex SQL queries and am having difficulty in mixing my understanding of procedural languages and of set-based operations in[详细]
2023-01-10 16:00 分类:问答