从PDF转换
转换为PDF
从PDF处理
从CAD转换
转换为CAD
从图片转换
转换为图片
文件压缩
电子书转换
使用技巧
客户端下载
Ask Time：2011-06-09T12:47:05 Author：Raje
I m new to postgresql and database part. I want to check function exit or not in postgresql using trigger before insert statement. any body know how to create trigger this?
I have a table called car and another table called inventory. car has a column called needs_oil_change (bool) inventory has a column called oil_change_due_count INTEGER I want to create a trigger t...
I am new to PostgreSQL and I am migrating to it from MySQL.Trying to creating Trigger in that.But can't done with it. This is my MySQL Query. delimiter $$ create trigger delVPNProfile before ...
Good evening . I'm working on a chat application using nodejs, prisma, postgresql. I would like 24 hours after the last message is created on a specific chat to be immediately deleted from the post...
I have a problem with PostgreSQL. I want to create a trigger and trigger function in a single query, so I can make trigger in a faster way. this is my trigger function: CREATE FUNCTION public....
Without use trigger and function how to create automatic date partitioning in PostgreSQL
My goal is to create a schema, based on the uuid of a user. I've therfor wrote a function that gets executed every time a user is created and confirmed. As the documentation says PostgreSQL Documen...
I installed postgresql and postgresql-plpython-10 (using apt) on a new machine running Ubuntu server 18.04 and I have reinstated a Postgresql database (extracted using pg_dumpall) from another mach...
I'm new to triggers. I have a function that I use to check if a password is valid that returns a boolean value. Is it possible to trigger a trigger only if the value is true? (This would update the
I am in the middle of converting an existing SQL Server 2005 DB into a PostgreSQL 9.0 DB. Everything works fine until now. I want to translate a SQL trigger into PostgreSQL but I have a problem wi...