extended by the user in many ways, for example by adding new • data types • functions 1. http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/postgres.html i Preface • operators • aggregate functions • index methods If more than one character set can be useful for a locale then the specifications look like this: cs_CZ.ISO8859-2. What locales are available under what names on your system depends on what was provided result, but at present the only accepted way to do it is PERFORM. An example: PERFORM create_mv(’cs_session_page_requests_mv’, my_query); 35.6.4. Doing Nothing At All Sometimes a placeholder statement

• data types • functions • operators • aggregate functions • index methods 1. http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/postgres.html i Preface • procedural languages And because of the liberal If more than one character set can be useful for a locale then the specifications look like this: cs_CZ.ISO8859-2. What locales are available under what names on your system depends on what was provided result, but at present the only accepted way to do it is PERFORM. An example: PERFORM create_mv(’cs_session_page_requests_mv’, my_query); 541 Chapter 35. PL/pgSQL - SQL Procedural Language 35.6.4

can be extended by the user in many ways, for example by adding new • data types 1. http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/postgres.html xxxviii Preface • functions • operators • aggregate functions If more than one character set can be useful for a locale then the specifications look like this: cs_CZ.ISO8859-2. What locales are available under what names on your system depends on what was provided result, but at present the only accepted way to do it is PERFORM. An example: PERFORM create_mv(’cs_session_page_requests_mv’, my_query); 36.6.4. Doing Nothing At All Sometimes a placeholder statement

can be extended by the user in many ways, for example by adding new • data types 1. http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/postgres.html xxxv Preface • functions • operators • aggregate functions If more than one character set can be useful for a locale then the specifications look like this: cs_CZ.ISO8859-2. What locales are available under what names on your system depends on what was provided result, but at present the only accepted way to do it is PERFORM. An example: PERFORM create_mv(’cs_session_page_requests_mv’, my_query); 36.6.4. Doing Nothing At All Sometimes a placeholder statement

can be extended by the user in many ways, for example by adding new • data types 1. http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/postgres.html xliv Preface • functions • operators • aggregate functions If more than one character set can be useful for a locale then the specifications look like this: cs_CZ.ISO8859-2. What locales are available under what names on your system depends on what was provided error unless it has an INTO clause as discussed in the next section. An example: PERFORM create_mv(’cs_session_page_requests_mv’, my_query); 37.6.3. Executing a Query with a Single-Row Result The result

can be extended by the user in many ways, for example by adding new • data types 1. http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/postgres.html xlii Preface • functions • operators • aggregate functions If more than one character set can be useful for a locale then the specifications look like this: cs_CZ.ISO8859-2. What locales are available under what names on your system depends on what was provided error unless it has an INTO clause as discussed in the next section. An example: PERFORM create_mv(’cs_session_page_requests_mv’, my_query); 37.6.3. Executing a Query with a Single-Row Result The result

can be extended by the user in many ways, for example by adding new • data types 1. http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/postgres.html xlviii Preface • functions • operators • aggregate functions broader dictionary; for example, a Snowball dictionary, which recognizes everything. 1. http://ficus-www.cs.ucla.edu/geoff/ispell.html 2. http://en.wikipedia.org/wiki/MySpell 3. http://sourceforge.net/projects/hunspell If more than one character set can be useful for a locale then the specifications look like this: cs_CZ.ISO8859-2. What locales are available under what names on your system depends on what was provided

• data types • functions • operators • aggregate functions • index methods 1. http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/postgres.html xliv Preface • procedural languages And because of the name that gives a list of words to eliminate. (PostgreSQL’s standard stopword 1. http://ficus-www.cs.ucla.edu/geoff/ispell.html 2. http://en.wikipedia.org/wiki/MySpell 3. http://sourceforge.net/projects/hunspell If more than one character set can be useful for a locale then the specifications look like this: cs_CZ.ISO8859-2. What locales are available under what names on your system depends on what was provided

• data types • functions • operators • aggregate functions • index methods 1. http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/postgres.html xlviii Preface • procedural languages And because of the TEMPLATE = ispell, DictFile = english, AffFile = english, StopWords = english ); 1. http://ficus-www.cs.ucla.edu/geoff/ispell.html 2. http://en.wikipedia.org/wiki/MySpell 3. http://sourceforge.net/projects/hunspell If more than one character set can be useful for a locale then the specifications look like this: cs_CZ.ISO8859-2. What locales are available under what names on your system depends on what was provided

can be extended by the user in many ways, for example by adding new • data types 1. http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/postgres.html lii Preface • functions • operators • aggregate functions present, PostgreSQL implements only the basic compound word operations of Hunspell. 1. http://ficus-www.cs.ucla.edu/geoff/ispell.html 2. http://en.wikipedia.org/wiki/MySpell 3. http://sourceforge.net/projects/hunspell If more than one character set can be useful for a locale then the specifications look like this: cs_CZ.ISO8859-2. What locales are available under what names on your system depends on what was provided