adspace


How to write pl sql in postgresql?

Answer Posted / Bhupendra Kumar

In PostgreSQL, PL/pgSQL is a procedural language that can be used for writing functions and procedures. Here's an example of a simple PL/pgSQL function:

```sql
CREATE OR REPLACE FUNCTION hello() RETURNS TEXT AS $$
BEGIN
RETURN 'Hello, World!';
END;
$$ LANGUAGE plpgsql;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the latest version of postgresql?

959