| From: | Erwin Brandstetter <brandstetter(at)falter(dot)at> |
|---|---|
| To: | pgadmin-hackers(at)postgresql(dot)org |
| Subject: | Reverse engineering of functions .. |
| Date: | 2010-05-19 21:31:51 |
| Message-ID: | 4BF458C7.1000706@falter.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-hackers |
Aloha!
Found another hitch with functions returning TABLE(). #191 says it all.
On a side note, the SQL example demonstrates another small issue:
... LANGUAGE sql
is transformed to
... LANGUAGE 'sql' -- note the quotes.
"langname" is a name, not a text. For backward compatibility the quotes
are allowed, but we should still not add them.
See ..
http://developer.postgresql.org/pgdocs/postgres/sql-createfunction.html
http://www.postgresql.org/docs/8.4/interactive/sql-createfunction.html
> { LANGUAGE langname
(...)
>
> langname
> The name of the language that the function is implemented in. Can
be SQL, C, internal, or the name of a user-defined procedural language.
> For backward compatibility, the name can be enclosed by single quotes.
Regards
Erwin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erwin Brandstetter | 2010-05-20 00:26:42 | 60 GB of error log. |
| Previous Message | pgAdmin Trac | 2010-05-19 21:14:34 | [pgAdmin III] #191: Functions returning TABLE lose necessary double quotes for names |