aboutsummaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/create_function.sgml
Commit message (Collapse)AuthorAge
* Add more appropriate markup.Peter Eisentraut2002-09-21
|
* Add a bunch of pseudo-types to replace the behavior formerly associatedTom Lane2002-08-22
| | | | | | with OPAQUE, as per recent pghackers discussion. I still want to do some more work on the 'cstring' pseudo-type, but I'm going to commit the bulk of the changes now before the tree starts shifting under me ...
* Remove unused system table columns:Peter Eisentraut2002-07-24
| | | | | | | | | | | | | | | | | | | | | | | | pg_language.lancompiler pg_operator.oprprec pg_operator.oprisleft pg_proc.proimplicit pg_proc.probyte_pct pg_proc.properbyte_cpu pg_proc.propercall_cpu pg_proc.prooutin_ratio pg_shadow.usetrace pg_type.typprtlen pg_type.typreceive pg_type.typsend Attempts to use the obsoleted attributes of pg_operator or pg_proc in the CREATE commands will be greeted by a warning. For pg_type, there is no warning (yet) because pg_dump scripts still contain these attributes. Also remove new but already obsolete spellings isVolatile, isStable, isImmutable in WITH clause. (Use new syntax instead.)
* pg_cast table, and standards-compliant CREATE/DROP CAST commands, plusPeter Eisentraut2002-07-18
| | | | | | | | | | | extension to create binary compatible casts. Includes dependency tracking as well. pg_proc.proimplicit is now defunct, but will be removed in a separate commit. pg_dump provides a migration path from the previous scheme to declare casts. Dumping binary compatible casts is currently impossible, though.
* Allow functions to be executed with the privileges of the function owner.Peter Eisentraut2002-05-18
| | | | I took the opportunity to remove the pg_proc.proistrusted field.
* Extend syntax of CREATE FUNCTION to resemble SQL99.Peter Eisentraut2002-05-17
|
* Update SQL-command reference pages for schema features.Tom Lane2002-04-23
|
* Restructure representation of aggregate functions so that they have pg_procTom Lane2002-04-11
| | | | | | | | | | entries, per pghackers discussion. This fixes aggregates to live in namespaces, and also simplifies/speeds up lookup in parse_func.c. Also, add a 'proimplicit' flag to pg_proc that controls whether a type coercion function may be invoked implicitly, or only explicitly. The current settings of these flags are more permissive than I would like, but we will need to debate and refine the behavior; for now, I avoided breaking regression tests as much as I could.
* Divide functions into three volatility classes (immutable, stable, andTom Lane2002-04-05
| | | | | | | volatile), rather than the old cachable/noncachable distinction. This allows indexscan optimizations in many places where we formerly didn't. Also, add a pronamespace column to pg_proc (it doesn't do anything yet, however).
* Spell checking and markup additionsPeter Eisentraut2002-03-22
|
* Revert quotes, 7.2 doesn't need them for CREATE FUNCTION.Bruce Momjian2002-03-01
|
* Oops, we didn't have single quotes around 'langname' in CREATE FUNCTIONBruce Momjian2002-03-01
| | | | manual page; pointed out by IRC user.
* Privileges on functions and procedural languagesPeter Eisentraut2002-02-18
|
* Use PostgreSQL consistantly throughout docs. Before, usage was split evenlyThomas G. Lockhart2001-12-08
| | | | between Postgres and PostgreSQL.
* Initial round of tweakage for man pagesPeter Eisentraut2001-11-18
|
* More cleanup of CREATE FUNCTION examples.Tom Lane2001-10-26
|
* Add CREATE OR REPLACE FUNCTION syntax to allow replacing a functionTom Lane2001-10-02
| | | | | definition without changing the function's OID, thereby not breaking rules, views, triggers, etc that depend on it. From Gavin Sherry.
* Put some kind of grammatical uniformity in the <refpurpose> lines.Peter Eisentraut2001-09-03
|
* Make LANCOMPILER clause in CREATE LANGUAGE optional. Allow "identifier"Peter Eisentraut2001-08-13
| | | | | | | | | | | | syntax for language names (instead of 'string'). createlang now handles the case where a second language uses the same call handler as an already installed language (e.g., plperl/plperlu). droplang now handles the reverse case, i.e., dropping a language where the call handler is still used by another language. Moreover, droplang can now be used to drop any user-defined language, not just the supplied ones.
* This patch adds support for %TYPE in CREATE FUNCTION argument and returnBruce Momjian2001-06-04
| | | | | | | types. This version has an elog() to remind the user the type resolution is not dynamic. Ian Lance Taylor
* Allow special '$libdir' macro to show up in object file path in CREATEPeter Eisentraut2001-05-19
| | | | | FUNCTION command. Guard against trying to load a directory. Update documentation some.
* In create_function there is a remark concerning SQL/PSM notBruce Momjian2001-04-28
| | | | | | | | | | being ratified as yet. This is certainly no longer true, it wasn't even true in Q2/1998 when I did a little research for Date's book. SQL/PSM had been published on 1996-12-15 as ISO/IEC 9075:4. So you might want to update that section. Frank Wegmann
* Refine some things to create better looking man pages.Peter Eisentraut2000-12-25
|
* Revise handling of oldstyle/newstyle functions per recent discussionsTom Lane2000-11-20
| | | | | | | | | in pghackers list. Support for oldstyle internal functions is gone (no longer needed, since conversion is complete) and pg_language entry 'internal' now implies newstyle call convention. pg_language entry 'newC' is gone; both old and newstyle dynamically loaded C functions are now called language 'C'. A newstyle function must be identified by an associated info routine. See src/backend/utils/fmgr/README.
* Change bool to boolean in docs.Bruce Momjian2000-11-02
|
* Add proofreader's changes to docs.Bruce Momjian2000-10-05
| | | | Fix misspelling of disbursion to dispersion.
* Fix typos and inconsistancies found by He WeipingThomas G. Lockhart2000-08-25
| | | | | | (aka Henry) <laser@zhangmai.com.cn>. Fix new problems in insert.sgml and create_function.sgml which kept jade from completing.
* Documentation updates to reflect TOAST and new-style fmgr.Tom Lane2000-08-24
|
* spell cleanupsBruce Momjian2000-07-22
|
* CleanupsBruce Momjian2000-07-22
|
* Start updating for the v7.0 release.Thomas G. Lockhart2000-03-27
| | | | | Use "generic functions" for math and other routines. Use SQL92 "type 'literal'" syntax rather than Postgres "'literal'::type".
* Updated user's guide to match new psql's output formatPeter Eisentraut2000-03-26
| | | | Fixed bug in createdb/alternative location
* Document formerly-undocumented WITH clause of CREATE FUNCTION.Tom Lane1999-10-02
|
* I have been working with user defined types and user defined cBruce Momjian1999-09-28
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | functions. One problem that I have encountered with the function manager is that it does not allow the user to define type conversion functions that convert between user types. For instance if mytype1, mytype2, and mytype3 are three Postgresql user types, and if I wish to define Postgresql conversion functions like I run into problems, because the Postgresql dynamic loader would look for a single link symbol, mytype3, for both pieces of object code. If I just change the name of one of the Postgresql functions (to make the symbols distinct), the automatic type conversion that Postgresql uses, for example, when matching operators to arguments no longer finds the type conversion function. The solution that I propose, and have implemented in the attatched patch extends the CREATE FUNCTION syntax as follows. In the first case above I use the link symbol mytype2_to_mytype3 for the link object that implements the first conversion function, and define the Postgresql operator with the following syntax The patch includes changes to the parser to include the altered syntax, changes to the ProcedureStmt node in nodes/parsenodes.h, changes to commands/define.c to handle the extra information in the AS clause, and changes to utils/fmgr/dfmgr.c that alter the way that the dynamic loader figures out what link symbol to use. I store the string for the link symbol in the prosrc text attribute of the pg_proc table which is currently unused in rows that reference dynamically loaded functions. Bernie Frankpitt
* Complete merge of all old man page information.Thomas G. Lockhart1999-07-22
| | | | ecpg reference page still needs formatting.
* Fix markup for docbook2man man page generation.Thomas G. Lockhart1999-07-06
| | | | | | | No big deal; fixed lots of other markup at the same time. Bigest change: make sure there is no whitespace in front of <term> contents. This will probably help the other output types too.
* Minor updates for release.Thomas G. Lockhart1999-06-14
| | | | | Split reference pages for CREATE TABLE AS and SELECT INTO to allow psgml (the emacs parser) to handle parsing.
* Update CREATE FUNCTION docs: mention use of AS clause withTom Lane1999-05-20
| | | | | INTERNAL functions, add a warning about trying to overload function names for dynamically loaded C functions (from old man page).
* Clean up to ensure tag completion as required by the newest versionsThomas G. Lockhart1998-12-29
| | | | | of Norm's Modular Style Sheets and jade/docbook. From Vince Vielhaber <vev@michvhf.com>.
* Minor cleanup in markup, especially in the Output section.Thomas G. Lockhart1998-10-30
|
* Markup and editing adjustments...Thomas G. Lockhart1998-09-16
|
* Very minor formatting fixup in the refentry id field to removeThomas G. Lockhart1998-09-07
| | | | | the trailing "-1". This makes a cleaner html output file name. Clean up a few refpurpose fields.
* First files for reference pages.Thomas G. Lockhart1998-05-13
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-03 23:36:57 +0000