[SQL] CREATE VIEW (dynamically)

[Emmanuel Engelhart]

code
<<
CREATE FUNCTION "requests_insert_after" () RETURNS opaque AS '
DECLARE
view_name   text;
BEGIN
view_name := ''request_'' || NEW.id;
CREATE VIEW view_name AS select * from groups;
return NEW;
END' LANGUAGE 'plpgsql';

CREATE TRIGGER "requests_insert_after" AFTER INSERT ON "requests"  FOR EACH ROW
EXECUTE PROCEDURE "requests_insert_after" ();>>

This code after an insertion on table "requests" give me this message :
<<
PostgreSQL said: ERROR: parser: parse error at or near "$1" 
>>

Why ?

Thx for any help.

Emmanuel Engelhart

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

[SQL] UNION & LIMIT & ORDER BY

[Emmanuel Engelhart]

Hi

Why this query doesn't work ?

<<
SELECT 
  '1' AS id 
FROM 
  users
ORDER BY id
LIMIT 1
UNION
SELECT 
  '2' AS id 
FROM 
  users
>>

And this one work ?

<<
SELECT 
  '1' AS id 
FROM 
  users
UNION
SELECT 
  '2' AS id 
FROM 
  users
ORDER BY id
LIMIT 1
>>

-- 
-
| Dans le cours d'un long gouvernement, on va au mal par une pente  |
| insensible, et ne remonte au bien que par un effort.  |
|   Montesquieu, "de l'esprit des lois" livre V/VII |
-----
Emmanuel Engelhart alias Kelson | ICQ UIN : 53388731 | TEL 01.58.46.04.79

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match