Обсуждение: Reverse engineering of functions ..

Поиск
Список
Период
Сортировка

Reverse engineering of functions ..

От
Erwin Brandstetter
Дата:
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

Re: Reverse engineering of functions ..

От
Guillaume Lelarge
Дата:
Hi Erwin,

Le 19/05/2010 23:31, Erwin Brandstetter a écrit :
> 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.
>

Sorry for not answering sooner. I'm real busy with the french
translation of the 9.0 PostgreSQL manual.

Anyway. Worked on this, commited a fix, should work now. At least, your
funny example works :)


--
Guillaume
 http://www.postgresql.fr
 http://dalibo.com