Search results
26 wrz 2024 · Use CREATE OR REPLACE FUNCTION to change a function definition without breaking objects that refer to the function. Also, ALTER FUNCTION can be used to change most of the auxiliary properties of an existing function.
- Create View
Description. CREATE VIEW defines a view of a query. The view...
- Devel
Chętnie wyświetlilibyśmy opis, ale witryna, którą oglądasz,...
- Current
Primary keys are useful both for documentation purposes and...
- 9. Functions and Operators
PostgreSQL provides a large number of functions and...
- Create View
26 wrz 2024 · Primary keys are useful both for documentation purposes and for client applications. For example, a GUI application that allows modifying row values probably needs to know the primary key of a table to be able to identify rows uniquely.
26 wrz 2024 · PostgreSQL provides a large number of functions and operators for the built-in data types. This chapter describes most of them, although additional special-purpose functions appear in relevant sections of the manual. Users can also define their own functions and operators, as described in Part V.
1 lis 2011 · Current terminology distinguishes between "procedures" and "functions". Both of these are "routines". Here is the documentation on what is now called "user defined procedures". –
PostgreSQL provides a large number of functions and operators for the built-in data types. This chapter describes most of them, although additional special-purpose functions appear in relevant sections of the manual. Users can also define their own functions and operators, as described in Part V.
26 wrz 2024 · SQL defines some string functions that use key words, rather than commas, to separate arguments. Details are in Table 9.9. PostgreSQL also provides versions of these functions that use the regular function invocation syntax (see Table 9.10).
27 sie 2012 · To get the definition of a function use pg_get_functiondef(): select pg_get_functiondef(oid) from pg_proc. where proname = 'foo'; There are similar functions to retrieve the definition of an index, a view, a rule and so on. For details see the manual: http://www.postgresql.org/docs/current/static/functions-info.html.
