Re: [HACKERS] Patch for user-defined C-language functions
Zeugswetter Andreas <andreas.zeugswetter@telecom.at>
From: Andreas Zeugswetter <andreas.zeugswetter@telecom.at>
To: hackers@postgresql.org
Date: 1999-09-14T07:44:25Z
Lists: pgsql-hackers
> Postgresql operator with the following syntax
>
> CREATE FUNCTION mytype3 ( mytype2 )
> RETURNS mytype3
> AS 'mytypes.so', 'mytype2_to_mytype3'
> LANGUAGE 'C'
>
> The syntax for the AS clause, which was 'AS <link-file>' becomes
>
> AS <link_file>[, <link_name>]
Sounds great !
But I think the intuitive Syntax in SQL would use ():
CREATE FUNCTION mytype3 ( mytype2 )
RETURNS mytype3
AS 'mytypes.so(mytype2_to_mytype3)'
LANGUAGE 'C'
Syntax:
AS <link_file>[(symbol_name)]
This is also how Illustra and now Informix does it.
(Instead of AS they say EXTERNAL NAME)
Andreas